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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ringovski
Helper II
Helper II

Color Formatting

Hi All,

I am trying to format a % measure called "Learning Percentage Completed" with red when it's >50 and <75 then with orange when its greater than 75. I've created a new measure called "color measure" and have tried using a IF statement ( I need to additional conditions later on).

 

When I just return the number from the IF it returns the correct number;

Color Measure = 
     VAR _per = [Learning Percentage Completed]*100
     RETURN

     _per

ringovski_0-1651801785668.png

 

But when I try comparing the numbers they are all orange when only 84.59 should be orange.

Color Measure = 
     VAR _per = [Learning Percentage Completed]*100
     RETURN

     IF(_per >50 && _per < 75, "Red","Orange")

ringovski_1-1651802021532.png

 

ringovski_2-1651802120078.png

This should be pretty simple but what am I missing?

 

Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@ringovski , This seems fine .

 

Try this

 

Color Measure = Switch( True() ,

[Learning Percentage Completed] >.5 && [Learning Percentage Completed]  <.75, "Red",

"Orange"

)

 

 

If this does not help
Can you share a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@ringovski , This seems fine .

 

Try this

 

Color Measure = Switch( True() ,

[Learning Percentage Completed] >.5 && [Learning Percentage Completed]  <.75, "Red",

"Orange"

)

 

 

If this does not help
Can you share a sample pbix after removing sensitive data.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I got it by adding a third condition, as it is technically correct at the moment becuase it changing values below 50 as these aren't 50 to 75.

 

Color Measure = 
     VAR _per = [Learning Percentage Completed]*100
     RETURN

     IF(_per >50 && _per < 75, "Red",

           IF(_per > 75, "Orange",""))

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.