cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Turn off date hierarchy?

I basically want to add a "Week Of" level to my date hierarchy. I've created a new field that captures the Monday of whatever date is specified, but PowerBI has automatically detected it as a date and created a hierarchy. This makes me unable to add the date to the existing date hierarchy. Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Turn off date hierarchy?

@Domenick 

You can turn it off in Options and Settings, under Data Load, by unchecking the box for automatic time intelligence.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

7 REPLIES 7
Highlighted
Super User II
Super User II

Re: Turn off date hierarchy?

@Domenick 

You can turn it off in Options and Settings, under Data Load, by unchecking the box for automatic time intelligence.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

Highlighted
Helper II
Helper II

Re: Turn off date hierarchy?

@PaulDBrown  Will that turn off the existing hierarchies for all the dates in this report? I don't want to do that 😥

Highlighted
Super User II
Super User II

Re: Turn off date hierarchy?

@Domenick 

Yes, it will turn off all existing date hierarchies. (that is actually how I work in all my projects. I much prefer creating my own columns in my date table and use those - especially relevant for week number and weekday number, where I need to specify the start day. for example, my weeks start on Monday, whereas PBI's default is Sunday)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Highlighted
Helper II
Helper II

Re: Turn off date hierarchy?

@PaulDBrownThanks! I went ahead and did what you suggested. But how can I get the months to appear as the full month name instead of numbered months (January instead of just "1") while still maintaining the proper order?

Highlighted
Resolver IV
Resolver IV

Re: Turn off date hierarchy?

@Domenick 

 

You can do this in the Dataview tab:

select monthname column, click column tools and click sort by column, then select monthNr.

sortbymonth.png

Highlighted
Helper II
Helper II

Re: Turn off date hierarchy?

@JefThanks. How did you get there? None of my screens have menus that looks like that, and I don't see a "Sort by column" anywhere. 

 

Edit: Found it in the Report View! But mine looks like this:

Capture.PNG

 

Perhaps because mine is a DirectQuery, but I'm not sure.

 

Thanks again.

Highlighted
Resolver IV
Resolver IV

Re: Turn off date hierarchy?

@Domenick 
It's because I'm using the new Ribbon from the november(?) update of Power BI.

https://powerbi.microsoft.com/en-us/blog/updated-ribbon-experience-for-power-bi-desktop/

 

You're welcome!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors