Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Copy conditional format from table to chart

Dear Friends, Appreciate advice on the below I have created a score cluster column chart by copying the visual from the score table. There are conditional formatting in the score table that change...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Anonymous 

    As mentioned by amitchandak , conditional formatting is not applicable to cluster bar chart with a legend field or multiple value fields. So you may need to unpivot you table columns first.
    Please check the sample file I attached for more details.

     

    For now, there is no content of description in the thread. If you still need help, please share more details to us.

    Best Regards,
    Community Support Team _ Eason

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , when you use more than one measure or legend, conditional formatting is not supported.

 

If this a legend you can try two axis -> concatenate label off and -> sort on axis and then you can do conditional formatting

I have shown that in power bi part here

Bar/Clustered Bar: https://youtu.be/2P5BBRN853c

 

Measure based conditional formattng

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4