The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |