Conditional formatting data labels not working correctly in clustered column chart

[Angel22]

Dear All,

Im trying to format data labels that are already in %, to color negative numbers red and positive green. (Power Bi Desktop)

The selection of number and percentage is blocked, number is grayed out.

I tried the solution below but does not work, it displays all numbers as red.

I would appreciate if someone could help me with this issue.

Thanks in advance

I use Power Bi Desktop June 2022 version

[Angel22]

Hi , amitchandak thank you for your answer.

Im not an expert, but what do you mean with row values? 

Those values are the total QoQ% difference between years coming from a quick measure.

[amitchandak]

@Angel22 , You are expecting color based on the bar(row) value. and I doubt that label formatting as of now works with overall value. Plot this measure on card visual and check does it follow that value.

Also, check the condition on the Value/bar formatting and check

[Angel22]

Hi , amitchandak

Creating a card visual and trying exactly the same parameters that i used for the data labels (but in effect - background) works perfectly.

So i dont get why it should not work for the data labels if the variables are the same.

[amitchandak]

@Angel22 , Log an issue or Idea

[Angel22]

Ok perfect, i reported it as an issue

[amitchandak]

@Angel22 , As far as I know as of now the label formatting work on grand total not on the row values.