Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datetime Hierarchy

Hi everyone!   I want to built area chart comparing two years by months. But I need to show my data not only by days (30 divisions) as it shown below:                 But I need to ...
Need Help
Tutorial Requests
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

    The data type of your date column is DateTime? If so, I think you could create an hour column, drag it to x axis and then expand Day and Hour.

    HOUR = HOUR('Table'[Date])

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi Anonymous ,

The data type of your date column is DateTime? If so, I think you could create an hour column, drag it to x axis and then expand Day and Hour.

HOUR = HOUR('Table'[Date])

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.