Filter by hierarchy selection

[thanasarnh]

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

[v-piga-msft]

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]

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]

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