reset date slicer hierarchy

[Anonymous]

Hi, is there a way to reset the date hierarchy in a slicer?  I removed the Quarter, Month and Day, but need to add them back.  Thanks!

[Gangula · Accepted solution]

You can do 2 things

1. remove the date field from the fields section and re-drag it to the field section.
2. right click on the date field and apply date and then re-apply date hierarchy.

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Aside from the solution @Gangula posted. You can also create hierarchy by yourself by right clicking "Date and Time of Loss" field->New Hierarchy, then add Year, Quarter, Month and Day to the Hierarchy. More details, please review this video or the blog. 

Best Regards,
Angelia

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Aside from the solution @Gangula posted. You can also create hierarchy by yourself by right clicking "Date and Time of Loss" field->New Hierarchy, then add Year, Quarter, Month and Day to the Hierarchy. More details, please review this video or the blog. 

Best Regards,
Angelia

[Gangula]

Wow, that's a really good feature. Thank you for the video @v-huizhn-msft.

But I don't think this is gonna help the OP's issue as he doesn't have separate columns for "Year, Quarter, Month and Day".  The "Year, Quarter, Month and Day" fields are auto-generated by PowerBI & Excel, when it detects the data type to be "Date" and if you set the field settings to "Date Hierarchy" instead of "Date"

[v-huizhn-msft · Accepted solution]

Hi @Gangula，

It's my pleasure to help you. Please mark the right/helpful reply as answer, or share your own workaround. More people will learn new things here. 

Thanks,
Angelia

[Gangula · Accepted solution]

You can do 2 things

1. remove the date field from the fields section and re-drag it to the field section.
2. right click on the date field and apply date and then re-apply date hierarchy.