Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

reset date slicer hierarchy

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's avatar
    Gangula
    8 years ago

    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's avatar
    v-huizhn-msft
    8 years ago

    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's avatar
    v-huizhn-msft
    8 years ago

    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

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Gangula
      Icon for Advocate II rankAdvocate II
      8 years ago

      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's avatar
        v-huizhn-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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's avatar
    Gangula
    Icon for Advocate II rankAdvocate II
    8 years ago

    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.