Platform Banner

Power BI - Conditional formatting Video

In this video, you will learn about conditional formatting and how to take it to the next level.
The video covers how to apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
It demonstrates how to use the quick analysis option in the ribbon for quick formatting, as well as how to have more control over the formatting by creating new rules.
You can format cells based on their values, such as using icon sets, and even format cells that are blank or contain errors.
This will help you make sense of your data and easily identify trends or important information.

3:35
3944 views

Description

Objectifs :

This tutorial aims to teach users how to apply conditional formatting to visuals in a report, specifically focusing on changing colors based on data values to enhance data interpretation.

Chapitres :

Introduction to Conditional Formatting
In this tutorial, we will explore how to apply conditional formatting to visuals in a report. Conditional formatting allows us to visually represent data in a way that highlights important trends and values, making it easier to interpret.
Applying Conditional Formatting to Sales Revenue Visual
We start by selecting the 'Month to Month Percentage Change in Sales Revenue' visual on the left side. This visual displays a list of months along with colored bars representing sales revenue changes. Our goal is to format these bars to show red for negative values and green for positive values.
Steps to Format Data Colors
To apply the desired formatting, follow these steps: 1. **Access the Visualizations Pane**: Click on the format button in the visualizations pane. 2. **Navigate to Data Colors**: Go to the 'Data Color' section. 3. **Disable Show All**: Uncheck the 'Show All' option to avoid manually changing colors for each month. 4. **Set Default Color**: Click on the FX button to open a pop-up window for formatting by categories. 5. **Choose Rules**: Select 'Rules' as the formatting option. 6. **Select Measure**: Choose the measure 'Sales Revenue Month to Month Percentage'. 7. **Define Rules**: - For positive values, set the rule: if the value is greater than or equal to 0, choose green. - For negative values, set the rule: if the value is less than 0, choose red. 8. **Apply Colors**: Use the 'More Colors' option to select custom colors if needed. 9. **Finalize**: Click OK to apply the changes.
Applying Conditional Formatting to Tables
Next, we will apply conditional formatting to a table visual that lists countries and their delivered quantities. Here’s how: 1. **Select the Table Visual**: Click on the visual displaying countries and quantities. 2. **Access the Format Button**: Go back to the format button. 3. **Conditional Formatting Section**: Under the conditional formatting section, apply the rule to the total quantity value instead of individual countries. 4. **Activate Data Bars**: Enable the data bars feature. 5. **Set Colors for Bars**: Adjust the colors for positive and negative bars. You can choose a light green for positive values and leave the negative bar as is or select a different color. 6. **Apply Changes**: Press OK to finalize the formatting.
Conclusion
In this tutorial, we learned how to apply conditional formatting to different visuals, enhancing the clarity and interpretability of data. By using color coding based on data values, we can quickly identify trends and make informed decisions based on the visualized information.

FAQ :

What is conditional formatting?

Conditional formatting is a feature that allows users to change the appearance of visual elements in a report based on specific conditions or rules, such as changing colors for positive and negative values.

How do I apply conditional formatting to a visual?

To apply conditional formatting, select the visual, go to the format button in the visualizations pane, navigate to the data color section, and set rules based on the values you want to format.

Can I customize colors in conditional formatting?

Yes, you can customize colors in conditional formatting by selecting 'more colors' in the color selection pane to choose your preferred color.

What are data bars in tables?

Data bars are visual indicators within table cells that represent the magnitude of values, allowing for quick visual comparisons of data.

What types of rules can I set for conditional formatting?

You can set various rules, such as specifying that values greater than or equal to a certain number should be displayed in one color, while values less than that number are displayed in another color.

Quelques cas d'usages :

Sales Performance Reporting

In a sales report, conditional formatting can be used to highlight months with negative sales growth in red and positive growth in green, allowing stakeholders to quickly identify trends.

Inventory Management

Using conditional formatting in inventory reports can help visualize stock levels, where low stock items are highlighted in red, prompting timely restocking actions.

Financial Analysis

In financial dashboards, conditional formatting can be applied to highlight profit margins, where margins below a certain threshold are marked in red, indicating areas needing attention.

Performance Dashboards

Conditional formatting can enhance performance dashboards by visually representing key performance indicators (KPIs), making it easier for managers to assess team performance at a glance.

Project Management

In project management tools, conditional formatting can be used to indicate project statuses, where overdue tasks are highlighted in red, helping teams prioritize their work effectively.

Glossaire :

Conditional Formatting

A feature in data visualization tools that allows users to change the appearance of a visual based on certain conditions or rules, such as changing colors based on value thresholds.

Visualizations Pane

A section in data visualization software where users can select and customize different visual elements for their reports, such as charts and graphs.

Data Color Section

A part of the formatting options in visualization tools where users can set colors for data points based on specific criteria.

FX Button

A button in data visualization software that allows users to apply advanced formatting options, such as rules-based color changes.

Rules

Conditions set by the user to determine how data should be formatted, such as specifying that values above a certain threshold should be displayed in a specific color.

Measure

A quantitative value that can be analyzed, such as sales revenue or quantities delivered, often used in data visualizations.

Data Bars

Visual indicators in tables that represent the magnitude of values, often displayed as colored bars within the cells.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This video is part of the following courses

Vu 5106 fois

Microsoft Power BI Video Training – Advanced

Dashboard, indicators (KPIs), activity tracking are part of your daily vocabulary? Discover how to quickly glean insights from your data using Power BI.

ALL COURSES