Visual formatting options in Power BI - Deep Dive

Overview - Visual formatting options

What is it?

Visual formatting options in Power BI let you change how charts, tables, and other visuals look. You can adjust colors, fonts, sizes, borders, and more to make your data easier to understand and more attractive. These options help highlight important information and improve the overall report design. Anyone can use them to make their dashboards clear and professional.

Why it matters

Without visual formatting, reports can look plain, confusing, or overwhelming. Good formatting guides the viewer’s eye to key insights and makes data stories easier to follow. It helps decision-makers quickly grasp important trends and take action. Without it, reports risk being ignored or misunderstood, wasting time and effort.

Where it fits

Before learning visual formatting, you should know how to create basic visuals in Power BI. After mastering formatting, you can explore advanced topics like custom themes, conditional formatting, and report design principles to create polished, user-friendly dashboards.

Mental Model

Core Idea

Visual formatting is like dressing your data so it looks clear, attractive, and tells the right story at a glance.

Think of it like...

Imagine you have a presentation slide with text and pictures. Visual formatting is like choosing the font style, colors, and layout to make your slide easy to read and engaging for your audience.

┌─────────────────────────────┐
│       Visual Formatting      │
├─────────────┬───────────────┤
│ Colors      │ Fonts         │
│ Borders     │ Backgrounds   │
│ Data labels │ Titles        │
│ Legends     │ Tooltips      │
└─────────────┴───────────────┘

Build-Up - 7 Steps

1

Foundation

Introduction to Visual Formatting

Concept: Visual formatting changes how your data visuals look without changing the data itself.

In Power BI, every visual has a Format pane. Here you can find options like colors, text size, and borders. For example, you can change a bar chart’s bar color or add a title with a bigger font. These changes help make your visuals clearer and more appealing.

Result

Your visual looks different but shows the same data. It becomes easier to read or matches your report style.

Understanding that formatting only changes appearance, not data, helps you experiment without fear of breaking your report.

2

Foundation

Using the Format Pane Basics

Concept: The Format pane organizes formatting options into categories for easy access.

Open a visual and click the paint roller icon to see the Format pane. You’ll see sections like 'Data colors', 'Title', 'Legend', and 'X-axis'. Clicking each expands options you can adjust with sliders, color pickers, or toggles. For example, turning on the 'Data labels' shows values on your chart.

Result

You can quickly find and change visual elements like colors, labels, and titles.

Knowing the Format pane structure saves time and helps you find the exact option you need.

3

Intermediate

Customizing Colors and Themes

🤔Before reading on: do you think changing colors affects the data values or just how they look? Commit to your answer.

Concept: Colors can be customized per data category or by applying report-wide themes.

You can pick specific colors for bars, lines, or slices to highlight categories. Power BI also supports themes that set colors for all visuals consistently. You can import or create themes with your brand colors. This keeps your report professional and consistent.

Result

Your report has a unified look and important data categories stand out visually.

Understanding color customization helps you guide viewers’ attention and maintain brand identity.

4

Intermediate

Adjusting Text and Labels

🤔Before reading on: do you think bigger fonts always improve readability? Commit to your answer.

Concept: Text elements like titles, labels, and tooltips can be formatted for size, font, and color to improve clarity.

In the Format pane, you can change font size, style, and color for titles, axis labels, and data labels. For example, increasing font size on axis labels helps viewers read values easily. You can also toggle data labels on or off to reduce clutter.

Result

Your visuals communicate data clearly without overwhelming the viewer.

Knowing how to balance text size and visibility prevents clutter and improves user experience.

5

Intermediate

Using Borders, Backgrounds, and Shadows

Concept: Borders, backgrounds, and shadows help separate visuals and improve report layout.

You can add borders around visuals to define their space. Background colors or images can make visuals pop or blend with the report theme. Shadows add depth, making visuals look layered and easier to distinguish.

Result

Your report looks organized and visually appealing, guiding the viewer’s eye naturally.

Using these subtle effects enhances report readability and professionalism.

6

Advanced

Conditional Formatting for Dynamic Visuals

🤔Before reading on: do you think conditional formatting changes data or just visual appearance? Commit to your answer.

Concept: Conditional formatting changes visual elements based on data values to highlight patterns or exceptions.

You can set rules so colors or font styles change automatically. For example, bars turn red if sales drop below a target. This helps viewers spot important trends without scanning numbers. Conditional formatting can apply to colors, data bars, or icons.

Result

Your visuals react to data changes, making insights obvious at a glance.

Understanding conditional formatting empowers you to create interactive, insightful reports.

7

Expert

Advanced Formatting with Themes and JSON Files

🤔Before reading on: do you think themes can control every visual formatting option? Commit to your answer.

Concept: Power BI supports advanced theming using JSON files to control many formatting aspects across reports.

You can create or edit JSON theme files to define colors, fonts, and visual styles globally. This allows consistent branding and saves time on manual formatting. Themes can also control default visual properties like border thickness or title font. Experts use this to enforce company standards and speed up report creation.

Result

Your reports have consistent, professional formatting applied automatically.

Knowing how to use JSON themes unlocks powerful, scalable formatting control for enterprise reporting.

Under the Hood

Power BI visuals have properties controlling appearance stored in a format model. When you change formatting, Power BI updates these properties in the report file and rendering engine. The rendering engine applies these styles when drawing visuals on screen or exporting. Conditional formatting uses rules evaluated at runtime to dynamically adjust styles based on data values.

Why designed this way?

Separating data from formatting allows flexibility to change appearance without altering data. The Format pane groups options logically for usability. JSON themes provide a scalable way to apply consistent styles across many reports, meeting enterprise branding needs.

┌───────────────┐       ┌───────────────┐
│   Data Model  │──────▶│ Visual Engine │
└───────────────┘       └───────────────┘
         │                      │
         ▼                      ▼
┌───────────────┐       ┌───────────────┐
│ Format Model  │──────▶│ Render Output │
│ (Colors, etc) │       │ (Screen/Export)│
└───────────────┘       └───────────────┘

Myth Busters - 4 Common Misconceptions

Quick: Does changing visual formatting alter the underlying data? Commit to yes or no.

Common Belief: Changing colors or fonts changes the data or calculations behind the visual.

Reality: Formatting only changes how data looks, not the data or calculations themselves.

Why it matters: Believing formatting changes data can cause unnecessary fear or confusion when adjusting visuals.

Quick: Can themes control every single formatting option in Power BI? Commit to yes or no.

Common Belief: Themes can control all visual formatting options automatically.

Reality: Themes control many but not all formatting options; some must be set manually per visual.

Why it matters: Expecting full control via themes can lead to frustration and inconsistent report styles.

Quick: Does bigger font size always improve readability? Commit to yes or no.

Common Belief: Making all text bigger always makes reports easier to read.

Reality: Too large fonts can clutter visuals and reduce clarity; balance is key.

Why it matters: Overusing large fonts can overwhelm viewers and hide important data.

Quick: Does conditional formatting change the data values? Commit to yes or no.

Common Belief: Conditional formatting changes the actual data values to highlight them.

Reality: It only changes visual styles based on data; data remains unchanged.

Why it matters: Misunderstanding this can cause incorrect assumptions about data integrity.

Expert Zone

1

Some formatting options behave differently depending on the visual type, requiring careful testing.

2

Conditional formatting rules can be combined with DAX measures for highly customized dynamic visuals.

3

JSON themes can override default visual styles but may conflict with manual formatting, needing priority management.

When NOT to use

Avoid heavy formatting on large datasets or complex visuals as it can slow report performance. Instead, use simpler visuals or aggregate data. Also, avoid over-formatting which distracts from data insights; focus on clarity.

Production Patterns

Professionals use corporate JSON themes for brand consistency, combine conditional formatting with KPI measures for dashboards, and use minimalistic formatting to keep reports fast and user-friendly.

Connections

User Experience Design

Visual formatting applies UX principles to data presentation.

Understanding UX helps create visuals that are not only pretty but also intuitive and easy to interpret.

Graphic Design

Visual formatting shares principles like color theory and typography with graphic design.

Knowing graphic design basics improves your ability to choose colors and fonts that communicate clearly and attractively.

Cognitive Psychology

Visual formatting leverages how humans perceive color, contrast, and layout.

Applying cognitive psychology insights helps design visuals that reduce confusion and highlight key data effectively.

Common Pitfalls

#1 Overusing bright colors and many fonts making the report look chaotic.

Wrong approach:

Set bar colors to random bright colors and use multiple font styles and sizes everywhere.

Correct approach:

Use a limited color palette and consistent font styles to create a clean, professional look.

Root cause:

Lack of understanding of visual hierarchy and consistency principles.

#2 Turning on all data labels on a crowded chart causing clutter.

Wrong approach:

Enable data labels for every data point on a dense bar chart.

Correct approach:

Use data labels selectively or only on key points to keep the chart readable.

Root cause:

Not considering visual clarity and viewer cognitive load.

#3 Expecting themes to fix all formatting issues automatically.

Wrong approach:

Apply a theme and ignore manual formatting adjustments needed per visual.

Correct approach:

Use themes for base styling but customize visuals manually as needed.

Root cause:

Misunderstanding theme scope and limitations.

Key Takeaways

Visual formatting changes how data looks without changing the data itself.

The Format pane organizes options like colors, fonts, and borders to customize visuals easily.

Conditional formatting makes visuals react dynamically to data, highlighting important insights.

Themes and JSON files help apply consistent styles across reports, saving time and ensuring branding.

Good formatting balances clarity, consistency, and aesthetics to make reports effective and professional.

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