cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sarah2283 Frequent Visitor
Frequent Visitor

undefined

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

 

 

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: undefined

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

154.png

And you could try to set Y axis to modify y axis

155.png

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.

Highlighted
sarah2283 Frequent Visitor
Frequent Visitor

Re: undefined

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

 

 

Community Support Team
Community Support Team

Re: undefined

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()

177.PNG

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.

sarah2283 Frequent Visitor
Frequent Visitor

Re: undefined

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

Community Support Team
Community Support Team

Re: undefined

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

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 49 members 985 guests
Please welcome our newest community members: