Dropdown for Parameter not showing

[HR3038511]

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 to select any of those values.

However, in the paramter there is no dropdown showing. I can only type a text. Does anybody know how to get a dropdown menu in the parameter so I can select any of the values from my list as my parameter?

Moreover the parameter is set to "Current" in the service. There is no way to change it overthere but users need to be able to adjust it overthere too.

Thanks!

[v-kpoloju-msft]

Hi @HR3038511,
Thank you for reaching out to the Microsoft fabric community forum. Thank you @kushanNa, and @AmiraBedh, and @lbendlin, for your inputs on this issue.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it.

Power BI Service does not support query based dropdowns for parameters, we will adopt an alternative approach. We will create a table and slicer to enable users to dynamically select values instead of using a parameter.

Please try this measure I have tried with some sample data in my end, it worked fine:

Create a Measure to Capture the Selected Period:
SelectedPeriod = SELECTEDVALUE(PeriodList[List], "Current")

I hope this could resolve your issue, if you need any further assistance, feel free to reach out. If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[v-kpoloju-msft]

Hi @HR3038511,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @HR3038511,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @HR3038511,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[kushanNa · Accepted solution]

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

[kushanNa]

hi @HR3038511 

As far as I know, dynamic M query parameters only work in DirectQuery mode. So, you will need to have your data queries in DirectQuery mode to get a dropdown list as a parameter.

[AmiraBedh]

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]

@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!

[lbendlin]

Define what you mean by "users".  Parameters can only be changed by the semantic model owner.