cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ngut47
Regular 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!


View solution in original post

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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors