Forum Discussion
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?
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.
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
Hi Anonymous
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/bar Chart (powerbi.com)
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!
3 Replies
Hi Anonymous
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/bar Chart (powerbi.com)
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, Anonymous
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
