Automatic Hierarchy from type date

[Anonymous]

Hello, 

I have the following visual setup where i am trying to show the number of views as a line chart over a series of dates as is seen below. 

As you can see, i can not drill up or down on this visual but i would to see the information by month qtr year etc. Normally when i have a "date" column of type date, Power BI automatically creates a heirarchy from the dates. 

Does anyone know wy it has not created it autmoatically in this case or a solution to this. Here is a screenshot of the data:

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

If you link the table with calendar table,the date hierarchy would be disappear.You may use calendar table's date column to replace it.For further,please refer to below post.

https://community.powerbi.com/t5/Desktop/Date-Hierarchy-falls-to-appear-when-joining-on-the-date/td-p/257605

Regards,