You create a table visual that displays the Revenue column for each sales region. You also create a measure named Revenue vs Target % that returns the percentage of the target that each region achieved. You must color the background of the Revenue column so that values appear green when the measure is 100 % or higher, yellow between 80 % and 99.9 %, and red below 80 %. Which option should you select in the Format by drop-down list when configuring conditional formatting for the Revenue column?
To apply discrete color bands that respond to filter context, you need a rule-based configuration. The Rules option lets you define numerical thresholds against a field or measure, such as Revenue vs Target %, and assign a specific color to every range. Color scale produces a continuous gradient, not banded colors. Field value applies colors that are already stored in another column or measure and therefore cannot interpret numerical thresholds on its own. Web URL returns a link rather than a color, so it does not meet the requirement. Therefore, selecting Rules is the only option that allows you to set green, yellow, and red backgrounds based on the measure's values.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
Can you explain how conditional formatting rules work in Power BI?
Open an interactive chat with Bash
What is the difference between 'Rules' and 'Color scale' in Power BI conditional formatting?
Open an interactive chat with Bash
Why can’t you use the 'Field value' option for this scenario?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .