Turn off date hierarchy?

[Domenick]

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?

[Anonymous]

This did not work at all for me.  I turned off "Time intelligence" and set the Date column to "Date only" in Transform data.  Nothing that I have tried allows me to use a date without the hierarchy.  

I am guessing the only way to do this is to create a text column containing a date string.  None of the options presented here work.  It would be nice to find something that does not require a special workaround or fix in Power BI.

[PaulDBrown · Accepted solution]

@Domenick 

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

[Domenick]

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

[PaulDBrown]

@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)

[Domenick]

@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?

[Anonymous]

@Domenick 

You can do this in the Dataview tab:

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

[Domenick]

@AnonymousThanks. 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:

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

Thanks again.

[Anonymous]

@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!