Bird
0
0

You set a conditional formatting rule but no colors appear in your table. What is the most likely reason?

medium📝 Formula Fix Q14 of 15
Power BI - Formatting and Design
You set a conditional formatting rule but no colors appear in your table. What is the most likely reason?
AYou forgot to save the Power BI file
BYou need to restart Power BI to activate formatting
CConditional formatting only works in charts, not tables
DThe rule applies to a different column than the one shown
Step-by-Step Solution
Solution:

  1. Step 1: Check rule application

    If the rule targets a column not visible or different from the displayed one, no colors show.

  2. Step 2: Eliminate other reasons

    Saving file or restarting Power BI is not needed for formatting to appear. Conditional formatting works in tables.

  3. Final Answer:

    The rule applies to a different column than the one shown -> Option D

  4. Quick Check:

    Rule column must match visible column [OK]
Quick Trick: Check rule targets visible column [OK]
Common Mistakes:
  • Thinking restart is required
  • Believing formatting only works in charts
  • Ignoring which column the rule applies to

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Line charts - Quiz 10hard Data Cleaning with Power Query - Unpivoting columns - Quiz 1easy Data Cleaning with Power Query - Handling null and blank values - Quiz 9hard Data Cleaning with Power Query - Handling null and blank values - Quiz 3easy Data Cleaning with Power Query - Removing duplicates - Quiz 10hard Data Cleaning with Power Query - Trim and clean text - Quiz 12easy Formatting and Design - Color themes - Quiz 2easy Formatting and Design - Color themes - Quiz 10hard Getting Data - SQL Server connection - Quiz 6medium Getting Data - SQL Server connection - Quiz 5medium