Conditional formatting in table with percentages

[Syndicate_Admin]

Good, I've been trying to apply conditional formatting to a column in a table that has percentages. Basically what I wanted to do was place red if the percentage was between 0 and 10, yellow between 10 and 20, and green between 20 and 100.

Using a measure, I managed to conditionally format that column as I show:

Now, if "I don't use a measure" to set the conditional formatting of the column I can't make it work. That is, if in the "Depending on the Field" drop-down (within the conditional formatting edition) I select the data count does not work:

If you look at the values in the % ASSIGNMENTS column, I set them as percentages:

I understand that in this second way I should walk... Do you know if it's an app error or am I wrong about something?

Best regards

Nicholas

[amitchandak]

@Syndicate_Admin , 1. Use number/ absolute value, In place of percent in the conditional formatting screen.

2. If it is % because you mark it % column. It means value is in the range of 0 to 1 and power bi showing it multiply by 100

3. 0 to 10 mean 0 to .1 and so on

[Syndicate_Admin]

Good morning, thanks for the answer. I tried that method and others but it doesn't work for me:

I'm left if it's not an application error.

Best regards

Nico

[v-deddai1-msft · Accepted solution]

Hi @Syndicate_Admin ,

In your case, you need to use measure instead of column field to set color rules. If you use the column , there is no percent options in summarization. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Syndicate_Admin]

Thank you, I wanted to get that doubt out, it would be nice if the tool allowed it without having to resort to a measure. Best regards