Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
sonam7
Employee
Employee

How to change x-axis interval for scatter plot

Hi All,

 

I have created a scatter plot and the values for my axis are 12,24,36,48,60,72. However, in scatter plot the x-axis is determined automatically and the chart looks like this:

 

sonam7_0-1619451280970.png

 

Can someone please suggest how can I change the intervals to multiples of 12 from 0 to 72 instead of the current intervals in multiple of 10.

 

Thanks!

5 REPLIES 5
v-angzheng-msft
Community Support
Community Support

Hi, @sonam7 

 

Check the type of the x-axis of the format

v-angzheng-msft_0-1619604373075.jpeg

If your is continuous, change it to by categorical.

I created a simple sample to illustrate this

Sample:

v-angzheng-msft_1-1619604373076.png

v-angzheng-msft_2-1619604373078.jpeg

v-angzheng-msft_3-1619604373080.jpeg

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello,

 

Unfortunately, I cannot change my x-axis into categorical values because for y-axis I want to display all the points instead of aggregating them using a aggregation function.

 

Can I not change the interval while having the x-axis as a continuous variable?

 

Thanks!

Hi, @sonam7 

 

As far as I know, changing the X-axis to a category value will not change the display of the Y-axis value. If you want to change the display of the Y-axis value, you can change the Y-axis value field or the Y-axis property.

v-angzheng-msft_0-1620956526378.png

Or, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate method.

 

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Hi,

Even I have similar kind of query 

I need to fix the scale on x axis.

0,1,2,10,100 this should be the interval

Is it possible to customize this way on a scatter plot

Please help

Thank you!

amitchandak
Super User
Super User

@sonam7 , I doubt you have the option for that if x-axis is based on a measure

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.