Color Coding for bars and Utilization % value

[Himanshi0291]

Hi Team,

I am working on showing the utilization % for different BUs on monthly, quarterly & yearly basis. For that reason I am using below clustered column chart and multi-row card and color coding should turn red ( 0-60%), Yellow (61-80%) and Green (Above 80%) based on Utilization % for both the graphs below. Can you please assist.

Thanks

  

[amitchandak]

@Himanshi0291 , You can create a color measure like one given below and use that in data color/conditional formatting with "Field Value" Option. But in case of Bar it will only work with one Value(Measure) and no legend

Switch( True(),
[Utilization %] <=.60 , "Red",
[Utilization %] <=.80 , "Yellow",
"green",
)

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values