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.
Super UserSorry 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