Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Solved! Go to 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.
Hi @hihihaha90909
Font color you have taken Number take Percentage.
and take Rules instead of Gardient
Hi @hihihaha90909
Try to create measure for color formatting
Like this.
and field option instaead of Rule/ Gradient option.
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
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.
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |