Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
KevinGesquiere
Frequent Visitor

Hierarchy Slicer multiple columns

Hi, I'm wondering if the following filter is possible in a Power BI report.

Hereby a small demo snipet of the data...

 

Capture.PNG

 

The columns Gender, Car and Continent are filter columns that the user can configure on a web interface. Based on the selected filters that the user has chosen, we dynamically add the columns to the table in our SQL Server database. 

Can we create a hierarchy slicer where we can add these columns with their values? To keep in mind; if the user adds a new filter we want to show it automatically in the below filter pane. We want to avoid that everytime a user choses a new filter we have to add it manually. 

 

Capture2.PNG

Thanks Kevin.

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@KevinGesquiere ,

 

In query editor-> Trasnform, click on [Gender], [Car] and [Continent] then click Unpivot, you will achieve a table like below:

1.PNG 

 

After applied&close, in custom visual market, search hierarchyslicer and install it, then you will achieve the result.

2.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@KevinGesquiere ,

 

In query editor-> Trasnform, click on [Gender], [Car] and [Continent] then click Unpivot, you will achieve a table like below:

1.PNG 

 

After applied&close, in custom visual market, search hierarchyslicer and install it, then you will achieve the result.

2.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.