condional formating

[MeTime]

I have a Rules with percetage format. So in card it gives a certain percentage value.
I want to apply conditional formatting where if  > 2,4% "Red" and >=2.0% and 2.4% "Yellow", 0% and 0.2%= Green but in Format Visual the options are greyed out. If I apply the below conditions  i dont have 2.6% is Red

Please any help

[audreygerred]

Hello! Based on what you have in your screenshot, 0 to less than 20% is green, 20% to less than 24% is yellow and 25% to 100% is red, so in this case 2.6% would fall in the green area (also, since the yellow rule has the upper limit as <24% and the red rule is >=25%, anything from 24% to less than 25% won't be colored.

• For green, change .2 to .002 (.2%)
• For yellow, change .2 to .02 (2%) and. 24 to .024 (2.4%)
• For red, change .25 to .024 and you can leave the 1 alone as long as you'll never have over 100% as a value. Otherwise, make 1 be 10 just to be on the safe side. 

[pradeep_kare12]

For this scenario you can use dax function, In power bi desktop go to the model view, and then create a new custom measure using DAX.

Card_Color =
VAR YourValue = [YourPercentageMeasure]

RETURN
SWITCH(
TRUE(),
YourValue > 0.024, "Red",
YourValue >= 0.020 && YourValue <= 0.024, "Yellow",
YourValue >= 0 && YourValue <= 0.002, "Green",
BLANK()
)

[MeTime]

Thanks @audreygerred 

 I try a condition 

• For green, change .2 to .002 (.2%)
• For yellow, change .2 to .02 (2%) and. 24 to .024 (2.4%)
• For red, change .25 to .024 and you can leave the 1 alone as long as you'll never have over 100% as a value. Otherwise, make 1 be 10 just to be on the safe side. 

but finally this picture

2,6 % this is a Total i want a colour a red 

[audreygerred]

You're welcome!

For green did you want it to be 0.2% (as stated in original post) which is .002, or do you want it to be 2% which would be .02?

If this solved your issue, please mark as solution. 

[MeTime]

Hai

@audreygerred 

To condition follow a orginal post but i try a condition color do not match in rules, i want to try your give solution that result all persentase its red colour 

is there any solution? 

Thank You

[audreygerred]

Hello! They're all red because I wrote the answer to match what you originally wrote which was green is 0% to .2% so I advised to use .002. I think you meant for green to be 0% to 2% so it should be .02 on green 🙂

[MeTime]

Thank You @ChiragGarg2512  but Value its not Match Format

please any help

[ChiragGarg2512]

@MeTime , Chnage the format to percentage of the field which is being used for conditional formatting.