Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • v-yuta-msft's avatar
    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