Scatter Plot - numerical X-axis summary

[Anonymous]

Hi all,

Got an issue with a scatter plot atm. I've got around the date issue by getting the date in a numerical format - i.e. today would be 20180510. However on the X-axis it's created a scale of 20180200, 20180250, 20180300, etc...

 

I want the scale to go 20180201, 20180301 for each month (as you're never going to go higher than say 20180331 for March). 

Any tips on how I could do this?

[v-yuezhe-msft · Accepted solution]

@Anonymous,

We are only able to set start and end values for x-axis in scatter chart, but unable to change the scale as you describe.

In your scenario, consider to create a R visual  to show date field in x-axis of scatter chart.

Regards,
Lydia