Forum Discussion
Automatic Hierarchy from type date
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:
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.
Regards,
1 Reply
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.
Regards,