July 3, 2021
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 (inter-related). I mean when i select country, only the specific OEM active in the particular country should get activated and vice-versa. Could you please help me with a way out.
October 18, 2018
July 16, 2010
I'm sure Alan's solution works, however it requires a refresh, and I imagine you want the Slicer to reflect the OEM upon selection of the country.
Also, I would argue that the layout of Table1 is not correct. It should be in a tabular format with one column for OEM. From there you could extract the OEMs for the selected country to a new table with a formula or a PivotTable. However, it's not clear what the end goal is or the other related components are in your file, so I can't advise further, other than to say, I think there is a better way to achieve what you want.