Forum Discussion
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 the background Color to Green for pass, yellow for 40-50 and pink for less than 40 values.
Seeking advice on how to duplicate the table chart Color format to the Clusterd Chart Bar (will show Green, Yellow or Pink)
Thank you very much.
Best Regards,
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
4 Replies
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
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
