Forum Discussion
Clustered bar chart X-axis with time
Hi v-qiuyu-msft,
Thanks. This works only if I use the date hierarchy and select "Day" from the drop-down. If I keep the date continuous, doing this prevents the hour-ticks from showing. If I don't do this and instead choose the date as a whole, I get the hour-ticks. I created the calendar table as you suggested using dates from the beginning of 2017 until the end of 2027. The column is formatted as a date column with no time associated with it. I then established a relationship with the table that has the "posted date" column. I checked and this column is also a date column with no time. The relationship created successfully.
But, like I said, this only works with the "continuous" selection if you break out the date hierarchy. It won't work if you keep the date "whole".
Using date hierarchy days after creating calendar tableUsing date as a whole after creating calendar table
Funny you used the word continuous. If you click on the visualization and go to the Formatting section, and to the X-Axis dropdown, change the Type from Continuous to Categorical and the issue will go away.
- sirlanceohlott6 years ago
Advocate III
HansTheEnforcer THANK YOU, I was experiencing this issue and this trick with the X-Axis worked like a charm!
- Anonymous6 years agoNot applicable
If you do this, you lose the ability to create a trend line 😕