Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
I am having the same problem.I have a measure which is a calculated percentage of other two column.Any ideas on how i can work this out
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?
Hmm, I actually just tried this and I'm not getting conditional formatting to work with measures, only columns...
I too can only use this function on columns and not measures. Are measures not supported for conditional formatting??
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |