Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using the Impact Bubble Chart and cannot format the labels.
Name: Computer
X-Axis: 36,947.37000000- Would like this formatted as currency
Y-Axis: 0.00000000- Would like to remove this if value is zero
Size: 36,947.37000000- Would like to remove
Label Image: https://ibb.co/YdzDT5t
Data Format: https://ibb.co/TKzwk4V
I also do not know why my Y-Axis begins at -100k when my data is not negative. Any suggestions would be greatly appreciated!
Hi sarah2283,
I think the y axis and chart label is by design(show its scale based on your value). You could try to use below to format label
And you could try to set Y axis to modify y axis
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much! This helps tremendously. I thought selecting currency would automatically give the number two decimal places, not sure why that is not the case. Is there a way to hide the axis label if the amount is zero?
Thanks,
Sarah
Hi
Did you mean if x axis =0, you want to hide this label, right? Based on my test, I find that this will always show in tooltip label, although I change this to blank()
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How would you change it to blank? Thank you so much for all your help!
Hi sarah2283,
You could try to use measure to set 0 to blank like below
Measure 2 = if(SUM('Table'[amount])=0,BLANK(),SUM('Table'[amount]))
But this seem not work in this chart.
Best Regards,
Zoe Zhi
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |