Hi Matthias,

I'm a bit confused by your question. You can't select every single value in the list in parameter editing, you can only select one.

If you want to select 'All', then I don't recommend parameters. The idea of the parameter is to limit the data you bring into Excel or your Data Model/PowerPivot. If you want to be able to select different views of the data e.g. one item from the list, or all, then you'd be better off doing this at the analysis level using PivotTable Slicers or similar.

In regards to using Wildcards in Power Query, it doesn't support them, but you can filter text using 'contains' or 'does not contain'.

If you still have questions please upload a sample Excel file so we can see an example of your use case and needs.

Mynda

Hi Mynda,

I am sorry for my bad English.

"..., you can only select one." The problem is, that this is not true. You must select one.

In 7.06 you use parameters for 2 different functions. One is to address the proper URL and the other is filtering the data received from the specified URL.

The later is for the given data set(s) not really ideal, and the idea was to add some comfort by giving the choice to select ALL.

Using 'contains' makes sense as there are combined entries like "National Holiday, Christian". Actually it can be "National holiday, Christian" and this triggered my question how to put this nuisance comfortably off by selecting ALL (i.e. no filter).

I put ==No Selection== on top of the list and this condition seems to work:

#"Filtered Rows" = if ParamType = "==No Selection==" then #"Renamed Columns" else Table.SelectRows(#"Renamed Columns", each Text.Contains([Holiday Type], ParamType))

Thanks,
Matthias

Hi Matthias,

Thanks for clarifying. It's great that you have a workaround. Although I'd still be inclined to avoid parameters for this scenario as Slicers would be more responsive to changes in the data displayed in the report.

Changing a Parameter requires a refresh of the query, whereas a Slicer will filter the PivotTable instantly.

Mynda

Hy Minda,

yes, that parameter which was build in for the filtering does not make a lot of sense - at least with the given data.

So the alternative was to take it out completely or to search a way to set it to "unfiltered".

Regards,
Matthias