Skip to main content

Reporting - Apply conditional formatting to a Table Visualisation

Matt Troy
Updated

In this article, we’ll show how to add conditional formatting to a table Visualisation in a Power BI report.

Conditional formatting makes key metrics stand out, and helps your report users to understand the data more easily. Specific cell colors, including color gradients, can be shown based on field values. 

In this video, we look at how to modify the background color of the cells in a column of data to show different levels of accreditation completion.

Steps to apply conditional formatting to a Table Visualisation

For this example, we'll add a conditional background colour to a Table.

  1. Add a Table Visualisation to a report
  2. Click to select the Table Visualisation on the report page
  3. Open the Visualisations panel:REPORTING_VisualisationPanel.png
  4. Select the 'down arrow' for the Column you'd like to add Conditional Formatting:REPORTING_VisualisationPanel_SelectColumn.png
  5. From the resulting menu options, select 'Conditional formatting' then, Background colour:REPORTING_VisualisationPanel_COnditionalFormatting_Background.png
  6. The default option is for a blue gradient background. Cells containing lower values are in light blue, higher values are in dark blue. If this is sufficient, select OK to close and apply. Colours can also be applied to a cell where the value falls in a specified range. Continue to step 7 to find out how
  7. Select 'Rules' from the 'Format Style' drop-down menu:REPORTING_VisualisationPanel_COnditionalFormatting_Rules.png
  8. Select 'New Rule':REPORTING_VisualisationPanel_COnditionalFormatting_Rules_new_v2.png
  9. For each new Rule, you can specify the conditional value and the colour of the conditional formatting. In this example, 3 rules are applied. The table cell will be coloured either red, amber, or green when the cell value (as percent) is in a specified range:REPORTING_VisualisationPanel_COnditionalFormatting_Rules_example.png
  10. Select OK to save and apply the conditional formatting

Ask the Community🤝

Want to connect with peers and hear how they are using the Fixed reports? Our customer Community is a great place to get quick, relatable advice - so jump in, ask your question, and learn from the wider customer Community. 

Get deeper learning in The Academy🎓

The Acadhttps://academy.kallidus-suite.com/emy provides structured learning paths you can follow at your own pace, along with live events where you can connect with the Kallidus team and fellow learners. Here's some relevant content to get you started:

Explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs. 

If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI. 

Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, or join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.

Related articles