March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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.
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
122 | |
99 | |
89 | |
74 | |
66 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |