Forum Discussion
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...
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.
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.
1 Reply
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.