Forum Discussion

Domenick's avatar
Domenick
Icon for Helper IV rankHelper IV
6 years ago
Solved

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 an...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    6 years ago

    Domenick 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.