How to remove Date Hierarchy

[lavdeep]

Hi,

How to remove Date Hierarchy

[AlB · Accepted solution]

Hi @lavdeep 

Go to  File --> Options and Settings --> Options --> Current File -> Data Load 

and turn  off 'Auto Date/Time' (under Time Intelligence)

[JPVent]

This doesn't work in 2023.  Can someone tell me how to remove/delete an unwanted hierarchy please?  Thanks

[Johag]

If you have On-object interaction active it works in the same way as before, just in a different place. 

Click on the Visual icon, go to column you want to change and click on the arrow, then chose column value or Date Hierarchy. 

[MDKCLIRResearch]

I have disabled 'Auto Date/Time' in setup and reloaded Power BI but cannot get rid of the hiearchy.  How do you really do this?

[Anonymous]

Without reuploading the data, you can do it in the visual itself:

[cchilton]

ty this is exactly what i needed to know 

[synergised]

From the icon it looks like you created it by mistake.  Just right click and select delete.

[synergised · Accepted solution]

Sorry wrong advise.... actually when you drag it into values, you can right click and select the date name instead of the Date Hierarchy - then it will display as a single date.

If you turn the auto date stuff off.. you would then have to have your own date tables.

[AlB · Accepted solution]

Hi @lavdeep 

Go to  File --> Options and Settings --> Options --> Current File -> Data Load 

and turn  off 'Auto Date/Time' (under Time Intelligence)

[Hernansio]

Disabling time intelligence disables ALL hierarchies in the file. If you need to keep some of them and get rid of one right click on the field (Visualizations/Columns), check it and uncheck "Data Hierarchy".