Forum Discussion
Color change do not apply on setting
I have a column that display a mesure % using divide function, I have tried to apply on settings the mesure to change the font color.
I have selected the fields:
But the table has a bug and do not apply the change.
I have tried also to apply this mesure
- Anonymous1 year ago
Hi, fbittencourt
I tried your second method and it is displaying the colors properly.
Please check out the attachment hope it helps.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
- HotChilliCommunity Champion
This is conditional formatting and it looks like a common mistake is being made.
Using 'percent' is not related to the data type of the field involved.
There's specific advice here : https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting#color-by-rules-for-percentages
- fbittencourtHelper IV
Just to bring more information, even though I apply the percentage as 0,20 and 1 ( 20%/100%) the color rules do not apply on whole the table, second the data type of the measure is percentage.
- BeaBFSuper User
fbittencourt hi! Can you attach the pbix file?
- fbittencourtHelper IV
Unfortunately not is sensitive data.tks
- AnonymousNot applicable
Hi, fbittencourt
I tried your second method and it is displaying the colors properly.
Please check out the attachment hope it helps.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- fbittencourtHelper IV
Peefect problem solved thank you vey much !!!