Forum Discussion
AdministratorConditional formatting in table with percentages
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
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
4 Replies
- amitchandak
Super User
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_AdminGood 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-msftCommunity Support
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
