Forum Discussion
Day Time Axis
Hi, I'm trying to do week on week comparison using line chart visual of datetime data. So my x-axis should be day-time (e.g. Mon 09:00) going from Monday 00:00 to Sunday 23:45 in 15 min increment...
Hi rchristie ,
First of all, because your X-axis values are text, you can't change the visual effects of the X-axis without changing the values. In other words, the X axis must be displayed as an categorical value.
Maybe you can split the day-time field into day and time columns (You can do it in Edit Queries) and use the "Drill up / down" feature to achieve the visual effect.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.