Log In
Register
Home
New Member
July 3, 2021
Offline
Hi Team,
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.
Regards
Hari
+91 7032707745
Trusted Members
October 18, 2018
Offline
I created a Parameter Query in the attached file with Power Query. You select in the drop downs the country and the OEM you want and it populates when you select Data--Refresh All
July 16, 2010
Offline
Hi Hari,
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.
Mynda
1 Guest(s)
