Visual formatting options in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Identify the effect of conditional formatting on a table visual

You have a table visual showing sales data by region. You apply conditional formatting to the 'Sales Amount' column to color cells red if sales are below 1000 and green if above 5000.

What will be the visual result for a region with sales of 3000?

A The sales amount cell will have no color formatting applied.

B The entire row will be colored green.

C The sales amount cell will be colored green.

D The sales amount cell will be colored red.

💡 Hint

Think about the conditional formatting rules and the sales value 3000.

The conditional formatting colors cells red if sales are below 1000 and green if above 5000. Since 3000 is between these values, no color formatting applies, so the cell remains uncolored.

❓ dax_lod_result

intermediate

Calculate average sales with formatting for display

Given a measure Average Sales = AVERAGE(Sales[Amount]), you want to display it with two decimal places and a dollar sign in a card visual.

Which DAX expression correctly formats the measure for display?

A Formatted Average Sales = FORMAT([Average Sales], "$#,##0.00")

B Formatted Average Sales = ROUND([Average Sales], 2)

C Formatted Average Sales = CONCATENATE("$", [Average Sales])

D Formatted Average Sales = FORMAT([Average Sales], "0.00")

💡 Hint

Consider which function formats numbers as currency with decimals.

The FORMAT function formats numbers as text with specified patterns. "$#,##0.00" adds a dollar sign and two decimals. ROUND only rounds but does not add currency symbol. CONCATENATE adds a dollar sign but does not format decimals. TEXT is not a valid DAX function.

❓ data_modeling

advanced

Best practice for formatting date columns in visuals

You have a date column in your data model. You want to show the month and year (e.g., 'Jan 2024') in a bar chart axis.

Which approach is best for formatting the date in the visual?

A Use the original date column and set the visual's axis type to categorical with a custom format string 'MMM yyyy'.

B Change the column data type to text with values like 'Jan 2024' in the source data.

C Create a measure that returns the formatted date string and use it in the axis.

D Create a calculated column using FORMAT(Date[Date], "MMM yyyy") and use it in the axis.

💡 Hint

Think about how Power BI handles axis fields and formatting.

Creating a calculated column with FORMAT returns a text value that can be used as a categorical axis with the desired format. Changing source data type to text is not flexible. Measures cannot be used as axis fields. Setting axis type alone does not apply custom formats to dates.

🎯 Scenario

advanced

Applying consistent color themes across multiple visuals

You want all your bar charts in a report to use the same custom color palette for categories to maintain brand consistency.

What is the best way to apply this color scheme across all visuals?

A Manually set the data colors for each bar chart visual individually.

B Create and import a custom report theme JSON file defining the color palette.

C Use conditional formatting on one visual and copy the visual to reuse colors.

D Set the default color in Power BI Desktop options under 'Data Colors'.

💡 Hint

Consider how to apply colors consistently and easily across many visuals.

Importing a custom report theme JSON file allows defining a color palette that applies to all visuals automatically. Manually setting colors is tedious and error-prone. Copying visuals copies colors but is not scalable. Default colors in options do not allow custom palettes.

🔧 Formula Fix

expert

Troubleshoot why conditional formatting is not applying

You applied conditional formatting to a matrix visual's 'Profit' column to show green for positive and red for negative values. However, the colors do not appear.

Which is the most likely reason?

A The matrix visual has 'Values' set to 'Don't summarize' which disables formatting.

B The conditional formatting rule is set on the field well but the visual is set to 'Show as table' mode.

C The conditional formatting is set on the wrong field or measure in the formatting pane.

D The 'Profit' column is a measure, and conditional formatting only works on columns.

💡 Hint

Check where the formatting rule is applied in the visual's settings.

Conditional formatting must be applied to the correct field or measure in the visual's formatting pane. Applying it to a different field or measure will not show colors. Measures can be formatted conditionally. 'Show as table' mode does not disable formatting. 'Don't summarize' is not a valid setting.