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.

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

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'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.