Conditional formatting in tables in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Conditional Formatting Color Based on Sales Value

You want to highlight sales values greater than 1000 in green in a Power BI table using conditional formatting. Which DAX expression correctly returns TRUE for sales above 1000 to apply the green color?

A SWITCH([Sales] > 1000, TRUE, TRUE, FALSE)

B IF([Sales] >= 1000, TRUE(), FALSE())

C IF([Sales] > 1000, TRUE(), FALSE())

D [Sales] > 1000

💡 Hint

Think about what expression returns TRUE or FALSE directly for conditional formatting.

In Power BI conditional formatting rules, a logical expression that returns TRUE or FALSE is used. The expression [Sales] > 1000 directly returns TRUE for sales above 1000 and FALSE otherwise, which is the simplest and correct approach.

❓ Function Choice

intermediate

Choosing the Right Function for Conditional Formatting

You want to apply conditional formatting to highlight the top 10% of sales in a Power BI table. Which DAX function is best suited to create a measure that returns TRUE for the top 10% sales?

A PERCENTILEX.INC(ALL('Sales'), [Sales], 0.9)

B RANKX(ALL('Sales'), [Sales]) <= COUNTROWS(ALL('Sales')) * 0.1

C TOPN(10, 'Sales', [Sales], DESC)

D FILTER('Sales', [Sales] >= 0.9)

💡 Hint

Ranking sales and comparing to 10% count helps identify top 10%.

The RANKX function ranks sales values. Comparing the rank to 10% of total rows identifies the top 10%. This returns TRUE for those rows, suitable for conditional formatting.

🎯 Scenario

advanced

Applying Gradient Color Based on Profit Margin

You want to apply a gradient color scale in a Power BI table to the 'Profit Margin' column, where low margins are red and high margins are green. Which conditional formatting setting should you use?

A Format by Color scale, set minimum color red, maximum color green, based on 'Profit Margin' values

B Format by Rules, set rule: if 'Profit Margin' < 0.2 then red, else green

C Format by Background color, set fixed color green for all rows

D Format by Field value, select a measure that returns color names

💡 Hint

Gradient colors require color scale formatting, not fixed rules.

Using 'Format by Color scale' with minimum and maximum colors set applies a gradient color effect based on the numeric values of 'Profit Margin'. This visually shows low to high values with color transitions.

❓ data_analysis

advanced

Identifying Rows with Missing Data Using Conditional Formatting

You want to highlight rows in a Power BI table where the 'Customer Email' field is blank or missing. Which DAX expression correctly identifies these rows for conditional formatting?

A LEN([Customer Email]) = 0

B [Customer Email] = ""

C OR(ISBLANK([Customer Email]), [Customer Email] = "")

D ISBLANK([Customer Email])

💡 Hint

Missing data can be blank or empty string; check both conditions.

Some missing emails may be blank (null) or empty strings. Using OR(ISBLANK([Customer Email]), [Customer Email] = "") covers both cases to highlight all missing data rows.

🧠 Conceptual

expert

Understanding Conditional Formatting Evaluation Context

In Power BI, when applying conditional formatting using a DAX measure on a table visual, what evaluation context does the measure use for each cell?

A The measure evaluates in the context of the current row and all filters applied to the table visual

B The measure evaluates only once for the entire table, ignoring row context

C The measure evaluates in the context of the first row only

D The measure evaluates in the context of all rows combined, ignoring filters

💡 Hint

Conditional formatting changes per row based on that row's data and filters.

Conditional formatting measures evaluate for each cell in the table visual, considering the current row's data and any filters applied. This allows dynamic formatting per row.