Conditional formatting on table

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.

Power BI Conditional formatting ,  Power BI Desktop

End-User also has the flexibility to apply custom color for highlight using custom visual created by DEFTeam.

Properties Parameters:

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.

Power BI Conditional formatting ,  Power BI Desktop

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:

Power BI Conditional formatting ,  Power BI Desktop

CONTACT US
USA: DEFTeam Solutions, Inc.
One Stamford Plaza, 263 Tresser Blvd. 9th Floor, Stamford, CT 06901
Tel. : +203-653-2293
Dubai: P.O.Box 340505, Almas Tower, 1st floor, DMCC Business Center Counter, Counter 12, Jumeirah Lakes Towers, Dubai – United Arab Emirates
Tel. : +971-55-3238612
Finland: DEFTeam Solutions Oy.
Myyrmäenraitti 2, 01600 Vantaa, Finland.
Tel. : +358-9-4245 4499
sales@defteam.com
PARTNERS