Hierarchy Slicer multiple columns

[KevinGesquiere]

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

Hereby a small demo snipet of the data...

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. 

Thanks Kevin.

[v-yuta-msft · Accepted solution]

@KevinGesquiere ,

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

 

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

 

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.