Forum Discussion
Dynamic Parameters with Multiple Selection
lbendlin I have a requirment where I have to use two parameters when I extract data. The firs paramter is Media Type, we have only 3 media types, and the second paramter is for Contract Tile. Eevry media type has several Contract tile. So I want to pick a media type or multiple media type, then i need the corresponding contract title related to the select media type's. Then I am using VBA to auto populate a template after the data extract. It will extract and save copy of a template with the contarct tile in a folder. Right now i want to acheive how i can get those two paramters to work dynamically.
Are you trying to do this in Power Query for Excel?
Yes sir I am trying this on Excel.
lbendlin If you dont mind can we exchange email address to i can explain you with the excel sheet.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523