Unlocking Power BI: The Secret of Paginated Report Parameters

[@BlighHedges]

Can confirm they have updated so when you choose a single value do not get an error anymore 12:00

[@CG_PT]

Hi, Thank you for this information. I have done this but at the end when I am trying to use my parameter, it comes up with an error message. It works up until I create the parameter list. Is there any way that I can get some help with this?

[@AlessandroDiMarco-y2n]

You may not need to have users suffer with selecting either one value or multiple (or support team be harassed).
Create the parameter normally (multi-value). You can use the excel sheet to feed its values as you did (but watch for Culture errors and eventually force the locale on the dataset to resolve the issue).
Pass the parameter as a string by joining the list array into a single comma separated value and capture it in Power BI M dataset with a regular String Parameter.
Split it back with a
paramList = Text.Split(yourparameter,",")
And use it to filter your table
#"Filtered rows" = if (yourparameter "") then
Table.SelectRows(#"Unfiltered Rows", each List.Contains(paramList, [yourcolumn]))
else
#"Unfiltered Rows"
works for me.