Forum Discussion
Conditional formatting for bar chart percentage data
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 :
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.
6 Replies
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 !!
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
Should the summarization be selected as sum? Can you try it
Tried that as well doesn't really makes a difference.
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.
This solution worked for me !! Thankyou so much !!
