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.