Forum Discussion

HR3038511's avatar
HR3038511
Helper I
1 year ago
Solved

Dropdown for Parameter not showing

Hi,    I created a parameter in Power Query based on list which I generate with another query in Power Query. This list has multiple values hence I would expect a drop down menu for the parameter t...
Need Help
  • kushanNa's avatar
    kushanNa
    1 year ago

    Sorry for jumping in here, but I believe Power BI Service does support query-based dropdowns for parameters when using "DirectQuery" mode.

    We can bind the dropdown column to a parameter and pass the selection—it will work in the service.

    Unfortunately, I don’t have a data gateway connected to my service right now to demonstrate an example.

    In this video, (unfortunalty he doesn’t publish it to the service), but I have tested this in one of my projects, and it works. https://www.youtube.com/watch?v=pXU_SpiBWUA&ab_channel=DataPlatformCentral

AmiraBedh's avatar
AmiraBedh
Super User
1 year ago

I think that your parameter is using a List, not a table. For example, your query should return something like:

{"HR3038511", "HR3038511 Helper I", "Helper I", "Partially syndicated - Outbound"}

If your query returns a table column, convert it to a list using:

= YourTable[YourColumnName]
Or :
= List.Distinct(YourTable[YourColumnName])

If you choose Any value instead of Query for Suggested Values, Power BI won't show a dropdown.

HR3038511's avatar
HR3038511
Helper I
1 year ago

AmiraBedh yes my input values for the dropdown are coming from a list: 

 

 

 

However, I can not see the dropdown in the parameter. Can you explain again what I need to do? I dont' fully understand from the explanation given. Thanks alot!