Forum Discussion
Conditional Formatting on Percentages
Is there any way to apply conditional formatting on percentages in a table?
Power BI handles percentages as text? I'm confused.
If I want to apply a conditional format to all values above 85%, I try entering 0.85 or 85 or 85% in the conditional formatting input fields. Power BI unfortunately applies the formatting to all values in the table, including those less than 85%.
My percentage is a result of a quick calc (% of column total).
Has anyone found a solution to this? I am having trouble with this too.