How to set Gauge as an expression in pivot table?

[Anonymous]

Hello,

I have an issue about gauge setting in pivot table.

I have a pivot table with one expression duplicate to have a text format and a gauge format.

I need to adapt my text and my gauge color  according to value which I have.

For example :

So, Normally I could have yellow for the first value, orange for the second and black for the last.

I use exactly the same condition for my text and my gauge but I don't have the color update.

Is anyone has an idea about this issue? Or maybe a workaround?

Thanks in advance for your help.