Show all Dates on continuous X axis

[kirill_vaynberg]

I would like to have a line chart that plots a numerical value against date. Everything seems to work except for the Date axis: it's always stuck at showing Month/Year at best. I would like to axis to actually show individual dates.

I have tried enabling Hierarchy but that is still stuck at Month/Year regardless of what type and level of drill down I am using. Besides, I have no need to the hierarchy features.

I would really rather not use a categorical axis as I need the results to show in the correct chronological proportion (observations are not taken on a regular basis)

The plot itself is fine, the Date Type & Format for the Date column is set to Date and (MM/dd/yyyy).

Ideally, I would like to just enter the step for that axis manually as per older versions of Excel

EDIT: Spelling

[v-qiuyu-msft]

Hi @kirill_vaynberg,

I'm not sure which criteria are used to determine the number of labels shown, but cased on my test, we can drag to increase chart width to make more date values display in X-axis.

You can submit an idea in Ideas forum.

Best Regards,
Qiuyun Yu