cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

Scatter Chart axis start & end values

Hello Experts,

 

Need your help!

 

I have a scatter chart and I have eneterd the start and end values for X-axis as 1 and 60 and for one dataset it looks good since values are below 60 but for another it goes around 200 and the bubble goes out of the screen. I have not kept these values balnk intesionally since I need to show values at 1 and not for 0.

 

Is there any way that the start and end values could be made dynamic? I mean it would adjust automatically at the maximum counts of the values with each dataset respectivley?

 

Please advise.

 

Thank!

1 REPLY 1
Community Support
Community Support

Hi @harshadsp,

 

 

>>I mean it would adjust automatically at the maximum counts of the values with each dataset respectivley?

It is analysed by datasource value range by visual itself.

 

For you scenario, you can try to create a calculated column with if statement to replace values which too big or too small values as static value.

 

If you still confused on this, share some sample data with expected result to help us clear your requirement.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors