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
Advocate IVChanging x-axis to 'categorical' is only a workaround not a solution. Yes, it works in many scenrios, but it doesn't work if you want to display trend lines or x-constant line, because in such cases you must use a continuous axis. And Power BI still stubbornly refuses to display all labels on continuous x-axis even when there is all the space in the world available (simple example attached). It’s now 2025 - 8 years since this issue was first flagged...