Forum Discussion
Helper IVTurn 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?
You can turn it off in Options and Settings, under Data Load, by unchecking the box for automatic time intelligence.
8 Replies
PaulDBrownCommunity Champion
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
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)
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.
