Conditional formatting for bar chart percentage data

[saadghojaria]

I have data in percentage format and I want to create conditional formatting in such a way 

100-95 : Green

<96 - >=80 = Yellow

<80 = Red

I have kept formatting in point format 95% = 0.95 but still not able to get red charts for my data. 

Edit : its not columns its a measure

Bar chart representation : 

[Anonymous · Accepted solution]

Hi @saadghojaria ,

According to your description, [total_in_time_dev_val] is a measure for which you want to create a conditional format, right?

Then we can create a color measure.

Color = SWITCH(TRUE(),
[total_in_time_dev_val]<=1 && [total_in_time_dev_val]>=0.96,"green",
[total_in_time_dev_val]<0.96 && [total_in_time_dev_val]>=0.8,"yellow",
[total_in_time_dev_val]<0.8,"red")

Setting the Conditional Format.

Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[saadghojaria]

This solution worked for me !! Thankyou so much !! 

[Kaviraj11]

Should the summarization be selected as sum? Can you try it

[saadghojaria]

Tried that as well doesn't really makes a difference.

[Kaviraj11]

Hi,

There should be an option to select 'Percentage' as a Unit instead of Number. Please adjust the value accordingly and try with that. 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[saadghojaria]

Actually I tried that but apparently what I found out that percentage is different.  
See this post : Solved: Conditional Formatting Not Giving Expected Result ... - Microsoft Fabric Community