SOLVED

Multiplt Slicer for different sets of data

New Contributor

Actually, I was facing an issue with one of my models and wanted your help. Just attaching a dummy for your reference. I have a table with multiple OEM for each country. I want to have just 2 slicers one each for OEM and Country and that are inter-related. Could you please help me with a way out. Regards

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@harinn777 As far as I understand, slicers can only be set up to control multiple Pivot Tables. But perhaps I'm mistaken. Anyway, if you "unpivot" your data, eg. with Power Query, you can create two slicers on the unpivoted data that are "interconnected".

 

Example attached.

Thank you