QT#70- Neat Idea For Adding Conditional Formatting Alternative to DATA BARS in Power BI TABLE VISUAL

In this short video, I'll explain my solution to add conditional formatting to data bars on a table visual in Power BI.

The standard functionality in a Power BI table visual allows you to add a data bar that represents the relative value displayed in the table cell. You can select the colour of the bar, but can't link this colour to a condition (with the expectation of choosing a different colour for negative and positive values).

In this solution, I explain how to add a red dot indicator next to the bar to indicate values that are outwith a given target threshold. This allows you to quickly draw the viewer's attention to the value that they need to investigate.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Recent Posts


About the author 

Jason Davidson

Jason Davidson is the founder of EffectiveDashboards.com. He is a maintenance and reliability engineer who uses Power BI every day to create dashboards that help him and others make better decisions. In his spare time, he likes running and has recently got into photography. He also loves spending time hanging out and larking about with his two daughters.

FREE Power BI Quick Start Course

Learn how to build a Power BI dashboard in under 90 minutes.

>