cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ngut47
Frequent Visitor

Set color scale with conditional formatting by Year (In legend)

I have a clustered bar chart, with a count measure in field values, category in axis and year in legend. 

 

Can I set colors by color scale with conditional formatting on my legend? 

ngut47_3-1638624418136.png

 

I want this

The colors were manually set, but what if i had more years i my legend. I would have to change one by one. 

ngut47_5-1638624567875.png

 

Is there a way to do this with conditional formatting instead of chosing color for each year? 

 

Maybe with measure or something?

 

Thank you in advance

1 ACCEPTED SOLUTION
jeroendekk
Resolver IV
Resolver IV

Hi @ngut47 
Unfortunately once you use the legend on a bar or column chart. The conditional formatting options disappeard. Even when you add the formatting first.

There are several ideas about this on the ideas website to change this.
Microsoft Idea  · Conditional formatting of data color on legend with Stacked or clustered column/ba...

I do not know of a "trick" to achieve this. It seems to be an option currently not offered. Although I think it should be.

Best regards,
Jeroen

If you liked my awnser, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!


View solution in original post

3 REPLIES 3
jeroendekk
Resolver IV
Resolver IV

Hi @ngut47 
Unfortunately once you use the legend on a bar or column chart. The conditional formatting options disappeard. Even when you add the formatting first.

There are several ideas about this on the ideas website to change this.
Microsoft Idea  · Conditional formatting of data color on legend with Stacked or clustered column/ba...

I do not know of a "trick" to achieve this. It seems to be an option currently not offered. Although I think it should be.

Best regards,
Jeroen

If you liked my awnser, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!


Would something like this work, a post from anonymous?

https://ideas.powerbi.com/ideas/idea/?ideaid=b03d0ec4-062c-ec11-b76a-281878de77da

Hi, @ngut47 

The idea  mentioned in the post has not been implemented. Currently, conditional format is not applicable to the color setting on the legend field. You can only manually set the data color.

Best Regards,
Community Support Team _ Eason

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 Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!