Scatter plot does not respect the difference of dates on the x axis

[JFG123]

I am trying to create a scatter graph of a continuous y variable (date) as the x-axis. As you can see below, the default scatters graph does not respect the difference between dates like the line graph does.

Scatter graph:

Exact same data using line graph and aggregation set to minimum value:

 The line graph gets the correct result with the spacing of the dates, how can I do this for the scatter graph?

[PhilipTreacy · Accepted solution]

Hi @JFG123 

Download sample PBIX file with the data and charts shown below

Dates are not continuous, they are discrete. You can only have fixed values for dates,they can't be half way between one date and another date.

Scatter charts plot the data you give them so you are seeing the discrete date values plotted on the x-axis.

If you are missing dates then these are omitted from the plot.

In this image the top visual has data for every date between the first and last dates, the bottom visual does not

regards

Phil

[amitchandak]

@JFG123 , Seems like scatter visual does not provide Axis type option - Continous. This option is there online not in scatter.

This because scatter we need show discrete values