Forum Discussion
Anonymous
7 years agoNot applicable
How to remove time from visualization
How do I remove the time from a visualization? The data is formated as a date in the format M/d/yyyy. If I change the X axis from Continuous to Categorical it fixes the issue, but it also elminates...
- 7 years ago
Anonymous ,
Currently in the date hierarchy there's no "time" level, so I'm afraid we can't show aggregation value based on time, we can only aggregate value based on day.
However, as a workaround, you can convert the date column to text type, in this way, each time in a day can be shown on the X-axis of a bar chart.
Regards,
Jimmy Tao
v-yuta-msft
7 years agoCommunity Support
Anonymous ,
Currently in the date hierarchy there's no "time" level, so I'm afraid we can't show aggregation value based on time, we can only aggregate value based on day.
However, as a workaround, you can convert the date column to text type, in this way, each time in a day can be shown on the X-axis of a bar chart.
Regards,
Jimmy Tao