Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

HierarchySlicer

Hi

I am new in PowerBI and Power Pivot

 I create a  4 columns  for  Hierarchy  product leverl  from level 1 to level 4 . I try to use HierarchySlicer. It works but I  notice  the product is dupicate  to show  For  example ALS is top  level  and it dupicate  from level 2 to  bottom level .  Do we have any DAX or any setting   do not show

F

 

Thank-you

 

3 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Hi there,

     

    You need to correctly create your Hierarchy levels. I would be happy to look at your hierarchy and can present you with sample file. 

    Pls post a snapshot of your data.

     

     

    Thanks & Regards,

    Bhavesh

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Bhavesh

      This is the  one of Catalgory . I  build by PowerPivot

      The max level is  only 4 . However some Catalgory may be less than 4 level even only 1 level .

      Thank-you  for your help

      Kenneth

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        9 years ago

        Hi Kenneth,

         

        From looking at your data, You need to create Parent Child Hierarchies in Your case to correctly see all the levels in your slicer.

         

        The below blog by Wise Owl have an excellent information on how to create such type of hierarchies in your data.

         

        http://www.wiseowl.co.uk/blog/s2479/parent-child-hierarchy.htm

        If you get stuck, let me know. Happy to show you a demo.

         

        Thanks & Regards,

        Bhavesh