Jul 03 2021 02:25 AM
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
Jul 03 2021 08:03 AM
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.
Jul 03 2021 08:03 AM
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.