Forum Discussion

rameezhashmi12's avatar
rameezhashmi12
New Member
2 years ago

Dynamic Parameters with Multiple Selection

I need to add two parameters at Run tab. 

1. MediaType
2. ContractTitle
 
Both parameters should be dynamic and should be able to pick all or multiple values. 
 
So when we pick mediatype and contracttitle from the parameters and refresh data, it should update data accordingly in the digital-combined-data-view and digital-contract-title tab. 
 
we are using power query to achieve this. and then vba runs and generates a summary_by_ clinet tab and details for every single contract mentioned in the digital-contract-title tab after the data gets filtered. 
Show and Tell
Tips and Tricks
Tutorial Requests

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Not clear what your question is. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

    • rameezhashmi12's avatar
      rameezhashmi12
      New Member
      2 years ago

      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. 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Are you trying to do this in Power Query for Excel?