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 y...
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!

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!

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

        Thank you, Tarun, very much again for your time!:)

        But it's still not what I mean, sorry!:) It's not about the content of the graph, but about appearance - in the Hierarchy slicer (containing years and months in my case) I have to scroll down within the graph, in the Slicer (HUBs in my case) the options pops up, so I can easily select them..

        Thank you:)