Forum Discussion
date hierarchy missing
hi all,
why the date hierarchy does show in the axis.
my date column is already formatted to date.
i have a calendar table & relationship is linked to it. Any advice?
Anonymous
Make sure you create Date table using calendar command
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
5 Replies
Anonymous,
Please check the below cases,
- No hierarchy will be created
- when the date table on the Many side relationship
- In Direct Query connections
- Try to mark your table as a Date table
- Right-click the table and select Mark as date table > Mark as date table in the menu - https://docs.microsoft.com/en-us/power-bi/desktop-date-tables#setting-your-own-date-table
Hope it will help you!
- No hierarchy will be created
Is it marked as date table? Right click on table Name. There is an option
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601amitchandak SivaMani I got error "date column can't have gaps in dates"
any idea how to solve that?
Hi Anonymous ,
It's impossible to sue "date hierarchy" if you use "Direct Query" connection model.
And as tested, the date hierarchy cannot be displayed if this column is linked to other column.
The impact of table relationships on date hierarchies
1:1
1:*
(1: the date can use hierarchy; *: can't)
*:*
Smmarize: only one side of the date can use the date hierarchy.
So you may need to modify your table model.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
