% Formatting

[Zakaria_1980]

HI,

Can please someone helps me about measure to put in order to put any % below 90% with background Orange and font Red.

Thanks

%

137,70%

23,50%

91%

90%

78%

300%

[Tahreem24]

@Zakaria_1980  Do the below setting for Background as well as for Font Color but for Font color use RED color instead of color as per below screen shot.

[Zakaria_1980]

when i followed the same, see what i m getting as colored in orange. why the last PoR % is not colored ?

how can i attach a draft of PBI report to help me?

thx

[v-janeyg-msft · Accepted solution]

Hi, @Zakaria_1980 

You need to change 'percent' to 'number'. 'Percent' represents the proportion of values, it doesn't represent values.

Try:

More details here:

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

[mh2587]

share the pbix file I will try

[Zakaria_1980]

it doesn't work, can you check in pBI. nothing changed when adding that measure to conditional formatting.

[mh2587]

Or make range in conditional formating but don't forget to put 0.9 in place of 90

[mh2587]

if(% < 0.9 , "Orange" )