cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daveed1973 Regular Visitor
Regular Visitor

Re: Date Hierarchy not showing

As far as I am aware the date heirarchy doesn't work with Direct Query. It doesn't on any of my direct query dashboards anyway.

 

An alternative would be to create a group based on the date field and add the date in Month bins for example. Just right click on the date field and click on new group.

perpor Member
Member

Re: Date Hierarchy not showing

no, in our reports hierarchy works fine with direct query from many months, on the server test and prod

perpor Member
Member

Re: Date Hierarchy not showing

with the workaround you suggest you loose the drill capability...

perpor Member
Member

Re: Date Hierarchy not showing

Someone else has experience ? Really date hierarchy has problems with Direct Query  ?? (I have some doubt about...)

perpor Member
Member

Re: Date Hierarchy not showing


I have clarified everything, in 'direct query' mode, date hierarchies are not active, and in our reports there was used only 'import' mode and not with direct queries, thanks to Daveed1973

Highlighted
davidhinckley Regular Visitor
Regular Visitor

Re: Date Hierarchy not showing

This is a frustrating issue. An easy (but frustratingly should-be-unnecessary) workaround is to create a calculated field:

 

DateIShouldntHaveToCreateThisExtraColumn = 'QueryPowerBIIsntReadingRight'[DateFromQueryThatForNoReasonIsntWorking]

The new column should give you a heirarchy without a problem.

 

And, if you're like me, it'll make you mad every time you see the duplication.

Shelley Member
Member

Re: Date Hierarchy not showing

Same problem. Created unnecessary field with date format and the hierarchy now shows. Very annoying. Thanks!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 281 members 2,976 guests
Please welcome our newest community members: