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
Advocate IPosting just too keep this thread going because 7 YEARS later and the issue is still alive and well.
Here are some interesting facts:
-This issue the age of my company.
-Microsoft has known about this issue for roughly 22% of my lifetime.
-If this issue were a child, it would be in school.
-On average, all of the cells in your body are replaced every 7 years, which means 36 trillion cells can replicate and arrange themselves into one of the most complex pieces of biological machinary on the planet in less time than it takes Microsoft to give you the option to show all the months on an x axis.
Nothing I've seen today is more hilarious. 😂