Visual formatting options in Power BI - Step-by-Step Guide

Introduction

Visual formatting options let you change how charts and tables look in Power BI. This helps make your reports clearer and easier to understand by adjusting colors, fonts, and layout.

When you want to change the color of bars in a sales chart to match your company colors

When your table looks crowded and you want to increase row height for better readability

When you want to add data labels to a chart to show exact numbers

When you need to hide chart elements like legends or titles to reduce clutter

When you want to apply consistent font styles across all visuals in your report

Steps

Step 1: Select the visual you want to format

- Report canvas

The visual is highlighted and its formatting options become available in the Visualizations pane

Step 2: Click the Format icon (paint roller) in the Visualizations pane

- Visualizations pane

The formatting options panel opens showing categories like Data colors, Title, Legend, and more

Step 3: Expand a formatting category, for example, Data colors

- Format panel

Color options for the visual's data elements appear

Step 4: Click a color box or slider to change colors

- Data colors section

The visual updates immediately to show the new colors

Step 5: Toggle options like Title or Legend on or off

- Format panel

The visual shows or hides the selected element accordingly

Step 6: Adjust font size or style in the Title or Data labels sections

- Format panel

Text in the visual changes to the new font settings

Step 7: Repeat for other formatting categories as needed

- Format panel

The visual appearance updates to match your formatting choices

Before vs After

Before

A bar chart with default colors, no data labels, and a visible legend

After

The bar chart shows company brand colors, data labels with exact values, and the legend is hidden for a cleaner look

Settings Reference

Data colors

📍 Format panel > Data colors

Change the colors used for data points in the visual

Default: Automatic colors based on visual type

Title

📍 Format panel > Title

Show or hide the visual title and customize its appearance

Default: On with default text and style

Legend

📍 Format panel > Legend

Display or hide the legend and adjust its style and position

Default: On for visuals that support legends

Data labels

📍 Format panel > Data labels

Show exact values on data points and customize label appearance

Default: Off

Common Mistakes

Changing colors in the Format panel but not selecting the visual first

Formatting options apply only to the selected visual, so changes won't show if no visual is selected

Always click the visual on the report canvas before adjusting formatting settings

Turning off the legend without adding clear labels or titles

Users may get confused about what data the visual shows without a legend or title

If you hide the legend, add a clear title or data labels to explain the visual

Summary

Visual formatting options let you customize how charts and tables look in Power BI.

You can change colors, fonts, labels, and visibility of elements like titles and legends.

Remember to select the visual first and keep your formatting clear for easy understanding.

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