What is conditional formatting in Power BI?

In Power BI, you can set conditional formatting for any element in your visuals (including color, size of the text, font color, background color, and so on) based on the values within your data. It allows you to mark trends, outliers, and particular points in the data to facilitate explanation in the report presentation, as the rules or conditions set for specific data or change in data are visually clear.

Key aspects of Conditional Formatting in Power BI:

1. Data-Driven Formatting:
   • You can apply conditional formatting to fields such as colors, icons, background color, font color, and data bars based on the data values.
   • For example, you can apply a red color to negative numbers and green to positive numbers in a table, or use a gradient color scale to represent values in a heatmap style.
2. Types of Conditional Formatting:
   • Font color: Change the color of the text based on specific rules.
   • Background color: Change the background color of a cell or data point according to its value.
   • Data bars: Use bars to represent the magnitude of values visually within a cell.
   • Icons: Use symbols like arrows, checkmarks, or stop signs to represent changes in values (e.g., a green check for positive change, red for negative).
   • Field value: Color formatting can be based on another field’s values (e.g., sales performance relative to a target).
3. How to Apply Conditional Formatting:
   • To apply conditional formatting in Power BI:
     • Right-click on a field (or click on the dropdown for the field in the visualization).
     • Select Conditional Formatting.
     • Choose the type of formatting (e.g., background color, font color, etc.).
     • Define the rules using either a fixed color range, a field value, or a dynamic range based on data (e.g., the min, max, or average value).
     • Power BI allows you to apply color gradients or custom rules, where the formatting can change depending on the data’s value or range.
4. Example Use Cases:
   • Revenue performance: Apply a green to red gradient to revenue numbers, where higher revenue is green, and lower revenue is red.
   • KPIs: Use icons (e.g., arrows) to show whether a KPI has improved or declined based on its target value.
   • Sales figures: Highlight the highest and lowest sales numbers with contrasting colors, making it easier for users to identify top-performing products or regions.