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
6 years ago

Domenick 

 

You can do this in the Dataview tab:

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

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

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.