Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Enrico501
Frequent Visitor

Conditional formatting of % on MAP Visual in power bI not working correctly

Hi, 

 

I have set a set of SLA % below and the conditional formating associated with them.

 

Enrico501_0-1682346135558.png

Based on the Above Italy for example should be in Yellow as the Delievered in SLA is 66.82%. 

Enrico501_1-1682346293971.png

Enrico501_3-1682346324813.png

however as you can see below Italy is showing in REd not Yellow even though SLA is above 50%. 

Enrico501_4-1682346411954.png

Any ideas on the issue? 

 

 

 

 

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @Enrico501 

 

You can try the following methods.

Color measure = SWITCH(TRUE(),
             [SLA%]>=0&&[SLA%]<=0.5,"Red",
             [SLA%]>0.5&&[SLA%]<=0.8,"Yellow",
             [SLA%]>0.8&&[SLA%]<=1,"Green" )

vzhangti_0-1682477380128.png

vzhangti_1-1682477407908.png

vzhangti_2-1682477432942.png

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.

View solution in original post

2 REPLIES 2
Enrico501
Frequent Visitor

It works. Thank You. This is the accepted solution. 

 

v-zhangti
Community Support
Community Support

Hi, @Enrico501 

 

You can try the following methods.

Color measure = SWITCH(TRUE(),
             [SLA%]>=0&&[SLA%]<=0.5,"Red",
             [SLA%]>0.5&&[SLA%]<=0.8,"Yellow",
             [SLA%]>0.8&&[SLA%]<=1,"Green" )

vzhangti_0-1682477380128.png

vzhangti_1-1682477407908.png

vzhangti_2-1682477432942.png

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.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.