Conditional formatting in tables in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply a color scale based on the Sales column.

Power BI

ColorScale = IF([Sales] [1] 1000, "Green", "Red")

Drag options to blanks, or click blank then click option'

A=

B<

C>

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using < instead of > causes wrong color assignment.

Using = compares for exact equality, which is too strict.

We use > to check if Sales is greater than 1000 to apply green color.

2fill in blank

medium

Complete the formula to highlight rows where Profit is less than 0.

Power BI

Highlight = IF([Profit] [1] 0, "Red", "NoColor")

Drag options to blanks, or click blank then click option'

A<

B<=

C>=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using > instead of < highlights positive profits incorrectly.

Using <= includes zero, which may not be desired.

We use < to find negative profits and highlight them red.

3fill in blank

hard

Fix the error in the formula to highlight high sales over 5000.

Power BI

HighSales = IF([Sales] [1] 5000, "Blue", "NoColor")

Drag options to blanks, or click blank then click option'

A==

B>

C<

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using = checks for equality to 5000 instead of greater than; == causes syntax error.

Using < highlights low sales instead of high.

Use > to check if Sales is greater than 5000 for blue highlight.

4fill in blank

hard

Fill both blanks to create a rule that highlights sales between 1000 and 3000.

Power BI

MidSales = IF([Sales] [1] 1000 && [Sales] [2] 3000, "Yellow", "NoColor")

Drag options to blanks, or click blank then click option'

A>

B<

C>=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using > instead of >= excludes 1000 sales.

Using < instead of <= excludes 3000 sales.

Use >= 1000 and <= 3000 to include sales in the range.

5fill in blank

hard

Fill all three blanks to create a conditional formatting rule that highlights products with Profit over 500, Sales under 2000, and Region equals "East".

Power BI

FormatRule = IF([Profit] [1] 500 && [Sales] [2] 2000 && [Region] [3] "East", "Highlight", "NoHighlight")

Drag options to blanks, or click blank then click option'

A>

B<

C==

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using == instead of = for string comparison causes syntax errors.

Mixing up > and < signs changes the logic.

Use > for Profit over 500, < for Sales under 2000, and = to compare Region to "East".