Back ground format color not working ?

[suvechha]

Hi there ,

 Back ground format color not working ?

My measure

Admitted ETP Breaches7Days has percent format , like below

the measure is -

Admitted ETP Breaches7Days

= DIVIDE(CALCULATE(SUM(ED[Numerator]),FILTER(MasterCalendar,MasterCalendar[Last_n_days]>=1), FILTER(MasterCalendar,MasterCalendar[Last_n_days]<=7)) ,CALCULATE(SUM(ED[Denominator]),FILTER(MasterCalendar,MasterCalendar[Last_n_days]>=1), FILTER(MasterCalendar,MasterCalendar[Last_n_days]<=7))

)

I am trying to format the back ground color like , but its not working ?

if the percent is from 0-75 then red

76 - 80 the amber

81- 100 the green.

[v-stephen-msft · Accepted solution]

Hi @suvechha ,

I think you have misunderstood the meaning of percentage here.

When you select Percent in this dropdown, you’re setting the rule boundaries as a percent of the overall range of values from minimum to maximum. So, for example, if the lowest data point was 100 and the highest was 400, the above rules would color any point less than 200 as green, anything from 200 to 300 as yellow, and anything above 300 as red.

An example table with rules-based background color formatting based on Percent in the Affordability column looks like this:

In your case, you should set as

For details, please kindly refer to

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

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.