Forum Discussion
Helper IDropdown for Parameter not showing
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
Community SupportHi 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.
- kushanNa
Super User
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
- 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.