Power BI Conditional formatting on table
Currently in Power BI Conditional formatting is possible on table and matrix visualization, but there are certain limitations in terms of functionality. An end user can do Power BI Conditional formatting of columns based on column values within the same column in Power BI Desktop. Cross-column Power BI conditional formatting text cannot be done using out of the features available on Power BI Desktop (i.e. Power BI Conditional formatting cannot be done when a single column is compared with another column)
E.g. If an end user wants to compare current year Sales figures with previous year figure region wise and want to highlight regions which have done poorly based on previous year figures. This cannot be achieved based on currently available features.
Using custom visual component in Power BI Conditional formatting above requirement can be met. DEFTeam created a custom visual in Power BI Conditional formatting text where end-user drags the columns to be compared and the cells in the table are highlighted accordingly
To use this component end-user needs to drag
- Categorical values which need to be displayed on a table
- Measures of Current Period which need to be compared
- Measures of Previous Period
Image shown is a sample screenshot of the dragged features.
End-User also has the flexibility to apply custom color for highlight using custom visual created by DEFTeam.
Below Threshold: Select highlighting color for values to be compared are less.
Above Threshold: Select highlighting color for values to be compared are more.
Image shown is the sample screenshot of the parameters.
Once all the required features are selected, then Power BI conditional formatting table gets displayed in Power BI Desktop with highlighted values as shown below: