Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
allasion
Frequent Visitor

PBI Desktop - Dates as a hierarchy

Hello, 

 

I created a new "Calendar" table summarising the date column from another table. I marked this as a date table. 

 

Capture.GIF

 

When creating a report, the 'date hierarchy' does not show for some reason. Can someone explain why this could be.

 

Thank yoCapture.GIF

1 ACCEPTED SOLUTION
rocky09
Solution Sage
Solution Sage

I had the same Issue, but I found, when I linked a table with Date table. I should drag the date field from Date table not from the other table. I am not sure about this, but it worked for me.

View solution in original post

2 REPLIES 2
rocky09
Solution Sage
Solution Sage

I had the same Issue, but I found, when I linked a table with Date table. I should drag the date field from Date table not from the other table. I am not sure about this, but it worked for me.

Thank you, this worked

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.