Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Conditional formatting data labels not working correctly in clustered column chart

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

 

Need Help

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous , 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.