Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have a condition on a measure that I calcualted a percentage of "women" in the gender column, and in the conditional formating I have the measure as a Rules in the Format Style I tell it will show green whenever its between 40% and 60% otherwise it will show red, but I don't get why 40% still is red and 62% as green, what's going on ?
Solved! Go to Solution.
Hi, @selected_
You can try the following methods.
Sample data:
Color Measure = IF([Percentage]>=0.4&&[Percentage]<=0.6,"Green","Red")
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @selected_ ,
make you selection as number instead of percentage. then use decimal instead of percentage value
Hi, @selected_
You can try the following methods.
Sample data:
Color Measure = IF([Percentage]>=0.4&&[Percentage]<=0.6,"Green","Red")
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately none of your examples works.
@selected_ My Perc column is in 0.0 to 1 format and I made it as Percetage from Format option.
Hello @selected_ ,
do it like this in the image as 0.4 and 0.6 and make it number
this image was taken from this blog, check it out https://hevodata.com/learn/power-bi-conditional-formatting/
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
Proud to be a Super User! | |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
108 | |
101 | |
93 | |
69 |
User | Count |
---|---|
172 | |
135 | |
132 | |
101 | |
95 |