Answered

A Date Hierarchy keeps appearing when creating dimDate table

(1) Share

Report

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

Categories:

Miscellaneous

Heirarchy2.png

Heirarchy.png

I have the same question (0)

All responses (7)

Answers (2)

CU04101541-0 21 on at

Like (1)

Report

I had the same issue. I couldn't resolve it.
I just carried on, regardless.

Was this reply helpful? Yes No
Suggested answer

CU08021907-0 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CU04020303-0 24 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

CU04020303-0 24 on at

Like (0)

Report

the solution to this is in another thread you'll find here

https://community.powerplatform.com/forums/thread/details/?threadid=76cce9c4-0e48-4b46-a05b-af3924abcd76

Was this reply helpful? Yes No
Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

Under Visualizations pane, change the column setting from "Date Hierarchy" to the column name e.g. DateOfAdoption.

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

For housekeeping, please mark the post as answered if you have no more queries.

Was this reply helpful? Yes No
Verified answer

CU01041709-0 7 on at

Like (0)

Report

Hi! I had this issue too, it comes from Power BI's Auto Time/Date feature. I found how to fix it here

How to remove default Date Hierarchy in Power BI - Power BI Docs

Hope this helps!

Was this reply helpful? Yes No