Forum Discussion
Show all Dates on continuous X axis
Hi kirill_vaynberg,
When you drag the date column to Axis of a line chart, it will automatically enable date hierarchy. You can check the column name instead of the Date Hierarchy. The date value in the X-axis will display based on the visual width and number of records in this date column. We are not able to set interval for date in the X-axis, we can just specify the start date and end date.
To display all date values in x-axis, the best option is to set X-axis type as Categorical, it will generate a horizontal scroll bar for us to view all data if there are two many records.
Best Regards,
Qiuyun Yu
Community SupportHi kirill_vaynberg,
When you drag the date column to Axis of a line chart, it will automatically enable date hierarchy. You can check the column name instead of the Date Hierarchy. The date value in the X-axis will display based on the visual width and number of records in this date column. We are not able to set interval for date in the X-axis, we can just specify the start date and end date.
To display all date values in x-axis, the best option is to set X-axis type as Categorical, it will generate a horizontal scroll bar for us to view all data if there are two many records.
Best Regards,
Qiuyun Yu
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