web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Microsoft Power Up Program Community / A Date Hierarchy keeps...
Microsoft Power Up Program Community
Answered

A Date Hierarchy keeps appearing when creating dimDate table

(1) ShareShare
ReportReport
Posted on by JS-04111714-0
When creating the dimDate table, a Date Hierarchy keeps appearing so when I add the date to the rows, it goes to a hierarchy rather than just showing dates. I have deleted the table and recreated it and got the same thing
Heirarchy2.png
Heirarchy.png
Categories:
Miscellaneous
I have the same question (0)
  • CU04101541-0 Profile Picture
    CU04101541-0 21 on at
    I had the same issue. I couldn't resolve it.
    I just carried on, regardless. 
  • Suggested answer
    CU08021907-0 Profile Picture
    CU08021907-0 2 on at
    Same thing happened here. I'm not an expert but it looks like it's coming from the date of the Loans in the loans table. 
     
    A bit later in the video Rory shows you how to mark the dimDate table as a "Date Table" which appears to resolve the issue. 
  • CU04020303-0 Profile Picture
    CU04020303-0 24 on at
    Same here,  there's something out of order,  if you do it later on in the course it shows correctly - almost like the table relationship needs to be there then it shows.    But, when you add loans it again flattens out with Full Name of Student.
    If you select "show rows with no data" then it shows correctly. -   
    I carried on regardless also 
  • Verified answer
    CU04020303-0 Profile Picture
    CU04020303-0 24 on at
  • Suggested answer
    w.p Profile Picture
    w.p 8,341 Super User 2026 Season 1 on at
    Under Visualizations pane, change the column setting from "Date Hierarchy" to the column name e.g. DateOfAdoption.
  • w.p Profile Picture
    w.p 8,341 Super User 2026 Season 1 on at
    For housekeeping, please mark the post as answered if you have no more queries.
  • Verified answer
    CU01041709-0 Profile Picture
    CU01041709-0 7 on at
    Hi! I had this issue too, it comes from Power BI's Auto Time/Date feature. I found how to fix it here 
     
    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Power Up Program Community

#1
timl Profile Picture

timl 61 Super User 2026 Season 1

#2
Hammed Profile Picture

Hammed 35

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 17 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Introduce yourself!

Product updates

Microsoft Power Platform Community release plans