Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
7 years ago
Solved

Hierarchy slicer

 

Hello,

I searched, but didn't find answer for below..:

When I drill down in my Hiearachy slicer, options (months) don't pop up as in the "normal" Slicer, please see below screen prints.

Thank you very much!

 

 

 

Need Help
  • tarunsingla's avatar
    tarunsingla
    7 years ago

    Not sure if I understand it correctly what you meant by normal slicer. But here's another approach that you may use to have month and year in a single slicer.

     

    1. Create a calculate column for Year Month, using FORMAT function.

    2. Change the DataType of this new calculated column to Date and set Format to Month, Year.

     

    Hope this helps.

     

    Regards,

    Tarun


    Did I answer your question? Mark my post as a solution!

6 Replies

  • tarunsingla's avatar
    tarunsingla
    Icon for Solution Sage rankSolution Sage
    7 years ago

    You can try creating a calculated column for the month and use that as an additional slicer next to the Year slicer.

     

    Regards,

    Tarun

    • KatkaS's avatar
      KatkaS
      Icon for Post Patron rankPost Patron
      7 years ago

      Thank you very much, Tarun, for your time and reply!

      But it is not really what I ment (but your reply helped me to solve another problem I also had with months!:)))

       

      I will try to be more precise of explanation of my problem about hierarchy slicer

      (and sorry if I missed something from your reply, I'm new to PBI, learning mainly from tutorials):

       

      I want my hierarchy slicer (in the attachment called "Reporting period") to have the same appearance as the "normal" slicer.

      (if I select a year of my hierarchy slicer I have to scroll down in the table to be able to choose the month which is not well-arranged, while in the normal slicer selection pops up and is easily accessed).

       

      Thanks a lot again!

      • tarunsingla's avatar
        tarunsingla
        Icon for Solution Sage rankSolution Sage
        7 years ago

        Not sure if I understand it correctly what you meant by normal slicer. But here's another approach that you may use to have month and year in a single slicer.

         

        1. Create a calculate column for Year Month, using FORMAT function.

        2. Change the DataType of this new calculated column to Date and set Format to Month, Year.

         

        Hope this helps.

         

        Regards,

        Tarun


        Did I answer your question? Mark my post as a solution!

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi KatkaS,

     

    I didn't encounter this problem on my side.

     

    In your scenario, please remove the Hierarchy Slicer visual, restart your Power BI desktop and import this custom visual again for a test.

     

    Regards,

    Yuliana Gu