Forum Discussion
Conditional formatting for bar chart percentage data
- Anonymous2 years ago
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.
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 !!
- saadghojaria2 years agoFrequent Visitor
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