topic Re: Multi value parameter for Power BI desktop report in Report Server

Multi value parameter for Power BI desktop report

contact2amitesh — Fri, 29 Sep 2017 04:19:58 GMT

Hi everyone,

i am doing POC on Power BI report so quite new on this one. the problem i am getting is to create a multi value selection from drop down parameter for power bi report.

I have created a data set from SQL query which is i am using as a parameter in the power bi report. When power bi opens, it prompt for the value from the drop down list which is populated with the data set. now here from that drop down i can choose only one value and my report runs perfectly fine based on that parameter but i want to enable this parameter drop down for multiple value selection similer in SSRS. please advice how can i do this.

In the snapshot below you can see in the drop down parameter list i can choose only one value.

Re: Multi value parameter for Power BI desktop report

contact2amitesh — Fri, 29 Sep 2017 04:03:36 GMT

Hi everyone,

i am doing POC on Power BI report so quite new on this one. the problem i am getting is to create a multi value selection from drop down parameter for power bi report.

In the snapshot below you can see in the drop down parameter list i can choose only one value.

Re: Multi value parameter for Power BI desktop report

v-yulgu-msft — Mon, 02 Oct 2017 05:55:25 GMT

Hi contact2amitesh,

Unfortunately, query patameter doesn't support multiple-selection right now. As you know, we can only choose a single value to filter dta source. If there is a few options for parameter, one workaround is to create multiple parameters, then, you can specify different values for different parameters to apply filters.

You caould submit this feature request at ideas page, your feedback is valuable to improve the level of our products. Thanks for your understanding.

Best regards,
Yuliana Gu

Re: Multi value parameter for Power BI desktop report

prasad_chengti — Fri, 27 Apr 2018 12:34:14 GMT

Still Dont we have any options for Multiselect in the same ? As this question was asked in 2017. Was this resolved in any of the updates?

Re: Multi value parameter for Power BI desktop report

olsengrantm — Mon, 07 Jan 2019 21:12:25 GMT

Still no multi value parameters?

Re: Multi value parameter for Power BI desktop report

Anonymous — Tue, 12 Mar 2019 09:23:26 GMT

Do we have this funtionality yet?

Re: Multi value parameter for Power BI desktop report

Anonymous — Sat, 07 Nov 2020 04:27:47 GMT

v-yulgu-msft Do we have this functionality in 2020 yet?