Date along x-axis on scatter chart not displaying correctly

[dnaman]

Hi all,

New to Power BI and trying to create a scatter chart based on the following:

X-axis - Date (in text format at the moment)
Y-axis - Movement (in inches)
Legend - 10 different 'things' we're tracking

The idea is to graph the movement of the 'things' around a zero-based midline over time.

When i try to create the scatter chart however, and i place the Date in the x-axis, it only gives me the count/count (distinct) for the date.
I don't want that, i just want the various dates, in chronological order, along the x-axis.

Can anyone give me a tip on what i need to do to display the dates separately along the x-axis in the scatter chart?

Thanks in advance

[v-huizhn-msft]

Hi @dnaman,

Have you resolved your issue? If you have, mark the right/helpful reply as answer. So more members like you will benefit from here.

Thanks,
Angelia

[v-huizhn-msft · Accepted solution]

Hi @dnaman,

Until now, the scatter chart only support number values in X-Axis and Y-Axis. Please review this feature request and vote it. For your requirement, please use the following way.

First, create a line chart, put date as x_axis, put corresponding fields as value and legend level.

Then, set the data colors as white color(highlighted in red line) and set the shapes of chart, you can set the marker shape(highlighted in blue line), and the marker color of different legend by choosing the different value(highlighted in yellow).
 

  

You will get the following expected result.



Best Regards,
Angelia