Forum Discussion
Card text conditional formatting on percentage
- 6 years ago
Hi Anonymous
I believe you might refer to this thread:
https://community.powerbi.com/t5/Desktop/Conditional-formatting-issue-on-percentage/m-p/729350
https://community.powerbi.com/t5/Desktop/Conditional-formatting-negative-numbers-red/m-p/758508
did not get completly. Try
<= .85 red
>.85 green
thanks for the reply - the issue is whatever my % is - its going Red. I'm trying to say if its a negative % then the text should be Red, i.e. if the metric returns -132.5% it should be Red. If the return on the metric is 85% then its positive so it should be Green. So any % be it 0 to infinity - so long as its positive - the text should be a Green color. On the rules for conditional formatting I did a simple calc of it its the minimum to less than 0 go Red. if its 0 or above - Green. My 85% went Red. I tried to tweak a bit, shown above, to include decimal numbers thinking that would address the % but its still not working.
Side Note - kudos to the msft developer who took away calling out if it was a number, %, etc in conditional formatting.....nothing like making using the tool more difficult, lol.
- Anonymous6 years agoNot applicable
Any thoughts? 🙂