Power BI - Formatting and Design
You want to highlight sales over $10,000 in a table visual by changing the row background color. Which formatting option should you use?
You want to highlight sales over $10,000 in a table visual by changing the row background color. Which formatting option should you use?
hard📝 Scenario Q15 of 15
Step-by-Step Solution
Solution:
Step 1: Understand conditional formatting
Conditional formatting changes visual style based on data rules, like sales > 10000.Step 2: Apply conditional formatting to table rows
Use Format pane's conditional formatting on Sales column to set background color for rows meeting the rule.Step 3: Differentiate from other options
Changing table background affects all rows; calculated columns don't change color automatically; filtering hides data, not format.Final Answer:
Conditional formatting with a rule on Sales column -> Option BQuick Check:
Conditional formatting highlights rows = B [OK]
Quick Trick: Use conditional formatting for data-based color changes [OK]
Common Mistakes:
- Changing whole table background instead of rows
- Using calculated columns without formatting
- Filtering data instead of formatting
Master "Formatting and Design" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes