undefined

[Anonymous]

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!

https://ibb.co/hDrzC5N

[dax]

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.

[Anonymous]

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

[dax]

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.

[Anonymous]

How would you change it to blank? Thank you so much for all your help!

[dax]

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