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
SivaMani
Resident Rockstar
Resident RockstarAnonymous,
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!