Conditional Coloring not working

[EaglesTony]

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).

[EaglesTony · Accepted solution]

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.

[EaglesTony]

Is it working for you ?

[EaglesTony]

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.

[DOLEARY85]

This works for me:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Rudy_D]

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

[EaglesTony]

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.

[DOLEARY85]

If you change all of them to Percent values and use percent type in the conditional formatting except for Values over 100% use:

>1 Number and <= 100 Percent 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on LinkedIn

[Rudy_D]

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

[EaglesTony]

For Rule #3 you mention 10 would that be then considered 1000% ?

[Rudy_D]

Yes, that's it.

[EaglesTony]

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

[DOLEARY85]

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 👍

[EaglesTony]

Thanks, but that did not work and even tried to move them around with no luck.

[Padycosmos]

You may change the Rule no. 3 as follows:

Rule 3 : > 0.99 & <=Max (You have to type Max in the box)

[EaglesTony]

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):

[DOLEARY85]

Are you able to share the PBIX file?

[EaglesTony]

Did you create a simple table and try to do the conditional formatting on it ?

[DOLEARY85]

Yeah, it was very basic with just a unique row and a percentage.

[EaglesTony]

Is it working correctly ?

If so, can you share what your field definition is and your conditional rule setup on this field ?