Forum Discussion

Bt123's avatar
Bt123
New Member
9 years ago

Conditional Formatting on Percentages

Is there any way to apply conditional formatting on percentages in a table?
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Bt123,

 

>>Is there any way to apply conditional formatting on percentages in a table?


Current power bi conditional format feature not support text, you can calculate the result as decimal, then switch the display mode(percent) at modding panel.

 

Regards,

Xiaoxin Sheng

rlien1's avatar
rlien1
Frequent Visitor
9 years ago

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

  • aslee's avatar
    aslee
    Helper I
    9 years ago

    Has anyone found a solution to this? I am having trouble with this too.