QT#69 – Power BI Data Label Conditional Formatting + Neat Dynamic Y-Axis Trick

Learn how to get the most out of Power BI data label conditional formatting for line charts.

In this video, I'll take you through the steps of setting up conditional formatting of data label colours. The colour of the data label will change depending on whether the data point is above or below a given threshold.

In this example, I'll use DAX code in a measure to build the conditional formatting rules. However, they can also be defined using the Power BI conditional formatting rule builder.

I'll then explain a neat workaround for making sure that the data labels at low and high points on your line graph don't get covered by the actual line. If the data points are obstructed by the line graph line it makes it hard to see the valve, particularly if it's one of the values that you've applied the conditional formatting to and you want it to stand out.

{"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.