Forum Discussion

thanasarnh's avatar
thanasarnh
Regular Visitor
8 years ago

Filter by hierarchy selection

Hi,

 

Beginner Power BI user here.

 

 

I created 3 hierarchies as following: organization, merchandise, customer.

 

Now I want to filter the visualization of table base on selected hierarchy (by select either organization, merchandise, customer).

 

If I select organization-> only organization hierarchy will show up on the table.

 

Is there anyway to use only 1 table and apply the filter?

 

Thanks for help in advance !

 

 

 

 

Spoiler
 

 

 

 

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi thanasarnh,

      

    You could have a try with the custom visual Hierarchy Slicer. You could import in the marketplace.

     

     

    For how to create the visual, you could have a reference of this video.

     

    In addition, I have a little confused about 'Is there anyway to use only 1 table and apply the filter?'.

     

    Best Regards,

    Cherry

    • thanasarnh's avatar
      thanasarnh
      Regular Visitor
      8 years ago

      Hi v-piga-msft,

       

      First of all, Thank you for you promptly reply!

       

      However, I tried your solution but it seems like it's not the solution that I'm looking for.

       

      By what I mean is that I would like to dynamically change axis by using list of filter.  I'm using hierarchy as an axis for the display table for user to able to drill down the table.

       

      Here is the video which show the result that I want.

      https://www.youtube.com/watch?time_continue=1&v=X8Or0-RgeSk

       

      Best regards,

      Thanasarn

       

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        8 years ago

        Hi thanasarnh,

         

        It is glad that you have solved the problem. Only thing that you'll have to notice, just always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

         

        Best Regards,

        Cherry