cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
irnm8dn
Post Prodigy
Post Prodigy

Conditional Formatting on Percentages - Really?

This really can't be that difficult...

 

I have a simple calculation in DAX, formatted as a percentage, and I want to conditionally format that when 100% Red, 80% Yellow and and so on.

 

I found some information in the community - but nothing particularly helpful.

 

 

1 ACCEPTED SOLUTION
ricardocamargos
Continued Contributor
Continued Contributor

Hi @irnm8dn,

 

The november's release has this function.

 

https://powerbi.microsoft.com/pt-br/blog/power-bi-desktop-november-2017-feature-summary/

 

You just should use 1 to red, 0.8 to yellow and so on (assuming your measure is formatted as percentage).

 

Ricardo

View solution in original post

5 REPLIES 5
ripstaur
Helper III
Helper III

I have tried this several ways...I have a column that calculates a percentage based on two other columns. The max it can be is 100%, and that (for better or worse - I didn't pick it) is the goal, and that's what they want to have "green." However, I have tried it using rules, setting yellow to less than 1 and green to "is" 1 (I also tried >= 1), and it stays yellow. If I back the 1 down to 0.93, it will turn green, but as soon as I put in a number larger than that, it goes back to yellow. Any ideas? 

 

Greg_Deckler
Super User
Super User

Hmm, I actually just tried this and I'm not getting conditional formatting to work with measures, only columns...


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

Anonymous
Not applicable

I too can only use this function on columns and not measures.  Are measures not supported for conditional formatting??

Greg_Deckler
Super User
Super User

Have you tried the "Color by rules" option? You can put in the decimal equivalents of the percentages as part of the rules and they will work, assuming that your calculation returns a number that you have formatted as % and they are not text.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop!
Microsoft Hates Greg's Quick Measures
Check out my latest book!

ricardocamargos
Continued Contributor
Continued Contributor

Hi @irnm8dn,

 

The november's release has this function.

 

https://powerbi.microsoft.com/pt-br/blog/power-bi-desktop-november-2017-feature-summary/

 

You just should use 1 to red, 0.8 to yellow and so on (assuming your measure is formatted as percentage).

 

Ricardo

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!