Conditional formating not working in Power BI

[selected_]

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 ?

[mussaenda]

Hi @selected_ ,

make you selection as number instead of percentage. then use decimal instead of percentage value

[v-zhangti · Accepted 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.

[selected_]

Unfortunately none of your examples works.

[Tahreem24]

@selected_ My Perc column is in 0.0 to 1 format and I made it as Percetage from Format option.

[Idrissshatila]

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💡