cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yhlworkacc
Regular Visitor

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.

 

yhlworkacc_0-1635493006678.png

 

Best Regards,

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @yhlworkacc 

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.

 

146.png

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

View solution in original post

4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi, @yhlworkacc 

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.

 

146.png

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

Thanks for provinding the file. Much appreciated.

yhlworkacc
Regular Visitor

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

Much appreciated for your time and help.

 

Best Regards,

amitchandak
Super User
Super User

@yhlworkacc , 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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!