Set slicer's color on a pie chart based on value

[Wael03]

Hello,

I have a report with a pie chart on it. The legend on the pie chart change with a slicer. The thing is I would like to set colors for the slicers not based on the legend but on the value. For example, now I set the value as : red for Cars, blue for Plane, green for Train. And now I would like to set them as : red for the biggest value on the pie chart, blue for the second, green for the third...

Do you know how to do that ?

Thank you !

[Wael03]

Thanks a lot !

[amitchandak · Accepted solution]

@Wael03 , Create a Rank Measure and then Try to create a measure like

Switch( True() ,

[Rank]=1, "Red",

[Rank]=2, "Blue",

[Rank]=3, "Green",

"Yellow"

)

Covert the pi to bar, Apply conditional formatting using bar color fx, Use field value option and choose this new measure

You can use Rank or Rankx for rank

Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...