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.

Practice

1. What is the main purpose of using visual formatting options in Power BI reports?

easy

A. To create new calculated columns

B. To add more data to the report

C. To change the data source

D. To make reports clearer and easier to understand

Solution

1. Step 1: Understand the role of visual formatting

   Visual formatting changes how the report looks, such as colors and fonts, to improve clarity.

2. Step 2: Identify the main goal of formatting

   The goal is to help users understand data quickly by making visuals clear and attractive.

3. Final Answer:

   To make reports clearer and easier to understand -> Option D

4. Quick Check:

   Formatting improves clarity = D [OK]

Hint: Formatting improves clarity, not data content [OK]

Common Mistakes:

• Confusing formatting with data changes
• Thinking formatting adds data
• Mixing formatting with data modeling

2. Which of the following is the correct way to change the background color of a visual in Power BI?

easy

A. Use the Format pane and select Background color option

B. Use the Data pane to select background color

C. Right-click the visual and choose Change Data Source

D. Edit the report theme JSON file manually

Solution

1. Step 1: Locate the Format pane in Power BI

   The Format pane is where you adjust visual appearance like colors and fonts.

2. Step 2: Select Background color option

   Within the Format pane, you find the Background section to change the color of the visual's background.

3. Final Answer:

   Use the Format pane and select Background color option -> Option A

4. Quick Check:

   Background color changed in Format pane = A [OK]

Hint: Format pane controls visual appearance settings [OK]

Common Mistakes:

• Trying to change background in Data pane
• Right-click menu does not change formatting
• Editing theme JSON is advanced and not needed here

3. You set the font size of a card visual to 20 in the Format pane. What will happen to the card's text?

medium

A. The text will become larger and easier to read

B. The text will become smaller

C. The text color will change to black

D. The card background will become transparent

Solution

1. Step 1: Understand font size effect

   Increasing font size makes text bigger and more readable.

2. Step 2: Apply font size 20 to card visual

   Setting font size to 20 increases the text size compared to default smaller sizes.

3. Final Answer:

   The text will become larger and easier to read -> Option A

4. Quick Check:

   Font size 20 means bigger text = A [OK]

Hint: Larger font size means bigger text [OK]

Common Mistakes:

• Confusing font size with color
• Assuming font size changes background
• Thinking font size makes text smaller

4. You tried to change the title font color in the Format pane, but the color did not update. What is the most likely reason?

medium

A. The data source is not connected

B. You changed the font size instead of color

C. The title is turned off in the Format pane

D. You need to refresh the report to see changes

Solution

1. Step 1: Check if title is enabled

   If the title toggle is off, color changes won't show because title is hidden.

2. Step 2: Confirm title toggle status in Format pane

   Turning on the title toggle allows font color changes to appear.

3. Final Answer:

   The title is turned off in the Format pane -> Option C

4. Quick Check:

   Title off blocks color change = C [OK]

Hint: Title must be on to change its color [OK]

Common Mistakes:

• Confusing font size with color
• Assuming data source affects formatting
• Thinking refresh is needed for formatting

5. 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

A. Change the table background color in Format pane

B. Conditional formatting with a rule on Sales column

C. Add a new calculated column with color names

D. Use the Data pane to filter sales over $10,000

Solution

1. Step 1: Understand conditional formatting

   Conditional formatting changes visual style based on data rules, like sales > 10000.

2. 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.

3. Step 3: Differentiate from other options

   Changing table background affects all rows; calculated columns don't change color automatically; filtering hides data, not format.

4. Final Answer:

   Conditional formatting with a rule on Sales column -> Option B

5. Quick Check:

   Conditional formatting highlights rows = B [OK]

Hint: 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