Conditional format background not work

[hihihaha90909]

even I change this to 3 or 0.03 it always fill to 0% value, where as with font color I need to choose '0.03' number, PBI so confused, I use the same function in excel and it work fine. 

Excel:

[Uzi2019]

Hi @hihihaha90909 
Font color you have taken Number take Percentage.
and take Rules instead of Gardient 

[Uzi2019]

Hi @hihihaha90909 

Try to create measure for color formatting

Like this.

and field option instaead of Rule/ Gradient option.

[hihihaha90909]

I want to use "gradient' , not distinct color for number, It already apply in Excel, why it cannot in PowerBI? This function not work as it expected to

[v-xiandat-msft · Accepted solution]

Hi @hihihaha90909 ,

@Uzi2019 's result is quite correct, and it is the fact that under the gradient rule there is always a gradual transition from the minimum to the maximum value that causes such a visual error

So the best way to refine the color of each data is to use a rule that

Best Regards,

Xianda Tang

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