I'm trying to create a drill down for charts with dates on my x-axis so that users can drill down from year to quarter to month to week to date.
My understanding is that a date hierarchy should automically be created for any date column as long as auto time intelligence is enabled in the settings.
Can anyone help me understand why I the hierarchy isn't present?
Did you check the Data Load section in Options for both Global and Current File? There is Auto date/time option in both. It is possible it is on in Global, but off in Current File. Also, I suggest adding in a date table and marking it as a date table, then utilizing that instead. http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/
Proud to be a Super User! |  |
Did you check the Data Load section in Options for both Global and Current File? There is Auto date/time option in both. It is possible it is on in Global, but off in Current File. Also, I suggest adding in a date table and marking it as a date table, then utilizing that instead. http://powerbiwithme.com/2023/08/01/the-custom-date-table-edition/
Proud to be a Super User! | |
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
