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

[Gauß452]

Does anybody have a solution for this problem?
If I want to see a trend or the whole year in a chart (without scrolling), there are gaps between the weeks (weekend  = gap).

[kirill_vaynberg]

Hi @v-qiuyu-msft

Thank you very much for the clarification. Are you able to share what criteria are uded to determine the number of labels shown? If I know the algorithm that uses visual width and number of records in this date column, I could try massaging my data and layout to match it in the future.

What pathways are there if i would like to propose setting interval for date in the X-axis as a future option?

[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