Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |