Copy conditional format from table to chart

[Anonymous]

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,

[v-easonf-msft · Accepted solution]

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

[Anonymous]

Thanks for provinding the file. Much appreciated.

[Anonymous]

Thank you Sir, I will try out what you have proposed. 

Much appreciated for your time and help.

Best Regards,

[amitchandak]

@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