Forum Discussion
Conditional Coloring not working
Hi,
I had one report working on Conditional Coloring, but this new one I can't seem to get it to do conditional coloring for some reason.
I have a column PCT Complete that in the data is defined as the following:
1) Data type: Decimal number
2) Format: Percentage
3) # of decimals: 0
4) Summarization: Sum
5) Data category: Uncategorized
Now for this field on my table visual I have the following conditional formatting for Background Color:
However all the backgrounds are green, when some have values of 93%(which should be yellow) and 151%(which should be red).
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.
19 Replies
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.
Hi,
I think it's because you have selected 'number' in your rules :). Everything is green because everything is < 1.
If your values are in %, you have to select '%' or you have to work with decimals.
Regards.
Rudy
Dont think that will work, as my last condition would be > 99 Percent and then what is the other side, as it only allows 100 percent, but I have values as 153 percent.
OK. So you have to work with decimals.
Try :
Rule 1 : >=0 & <= 0.76
Rule 2 : > 0.76 & <= 0.99
Rule 3 : > 0.99 & < 10
That I cannot.
I think if you build a simple table with 1 row with the attributes mentioned above and then add a table visual to the report.
This works for me:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Is it working for you ?
