The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi all I have 4 slicers from 4 different columns as shown below. I want to combine all the 4 slicers into one slicer. If select one Slicer button the other slicer button should be disabled like in a single slicer. Currently as they are individual slicers if select two slicers the other one is not disabled like in a single slicer. Please help me on this.
Hi @Anonymous ,
I think you can use HierarchySlicer to solve this problem, the steps are as follows:
1: In the Query Editor, select the four fields you need for Combine, select Unpivot Column, and then will generate two fields, Attribute and Value:
2: Search for HierarchySlicer in the marketplace, then add:
3: Select HierarchySlicer, drag Attribute and Value into the field, the result is as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.