Progressive bar inside cells

[shompy08]

Hi everyone! im having a request and i dont know how to solve it.

i have this table

Column 1 and column 2 are different real expenses and the column 3 is the budget. I need to apply a progressive bar from 0 to 100% according the real expenses reach the budget. As you see in the example, sometimes, real expenses are higher than budget, so i need to change the bar color for another one, red for example.

Is it possible to make this with conditional format or another formula? 

In the image i could apply the progressive bar but i can't change the color for red when the value is higer than 100%  or show different colours if the bar approaches to 100%

Hope you can help me.

Thx in advance!

[shompy08]

Thx both! i guess it's not possible, but i will show to  my boss this alternatives and the other standar options.

[v-kkf-msft]

Hi @shompy08 ,

Please create the measure, then format the background color of the cells.

Color = IF ( [Measure%] < 1, "Green", "Red" )

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KerKol]

I don't believe so, you could change the background colour of the cells.

Otherwise you could use SVG measures Solved: Bullet Chart Sparkline SVG Not Rendering in Table - Microsoft Power BI Community