Forum Discussion
Back ground format color not working ?
Hi there ,
Back ground format color not working ?
My measure
the measure is -
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.
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.
1 Reply
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.