Forum Discussion
Conditional Coloring not working
I think I found a solution to it.
The field PercentComplete is of Data type "Decimal Number" and Format "Percentage" with 0 decimal places.
A new field needs to be created to convert this into a whole number (i.e. newfield = PercentComplete * 100) and this new field needs to be of Data type "Whole number" and Format "General" asd Auto as decimal places.
In the conditional formatting, I had to use this new field that is a whole number and not the percentage field.
That did not work as I have a few at 25% as yellow and not green, so at 8% as red and not green and one that is 151% as yellow and not red.
Here is my setup:
My field is set to Data Type: Decimal Number, Format: Percentage and no decimal places
Hi, try:
>= 0 Percent <=76 Pecent
>76 Percent <= 99 Percent
>1 Number <=100 Percent
You may have to adjust the order to have the last one first but try it in that order to start with
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Still no luck after changing..I have something 5% in red and nothing in yellow.
Here is the setting (I did change to Max, but when I went back in, this is what it shows):
Thanks, but that did not work and even tried to move them around with no luck.
Are you able to share the PBIX file?
Did you create a simple table and try to do the conditional formatting on it ?
Yeah, it was very basic with just a unique row and a percentage.
Is it working correctly ?
If so, can you share what your field definition is and your conditional rule setup on this field ?
You may change the Rule no. 3 as follows:
Rule 3 : > 0.99 & <=Max (You have to type Max in the box)