Paginated Report using PBI Dataset - Multi select optional parameter

[Anonymous]

Hi DEVs,

I am creating a pagingated report using PBI Dataset. I need to add 1 optional multi select parameter in report.

This is my main query:

EVALUATE

SUMMARIZECOLUMNs (

Table[ProductID],

Table[ProductName],
FILTER ( VALUES ( Table[ProductID]), Table[ProductID]) = @ProductID )

)

This dataset I created for parameter that will give me all product IDs in drop down

EVALUATE

SUMMARIZECOLUMNs (

Table[ProductID]

)

The above query is working for single select parameter only.

How to make it multi select and optional.

[Anonymous]

When I am checking Allow null values and Aloow multiple values. It's giving error that A multi-value parameter cannot include null values

[Anonymous]

I tried that RS Custom Dax Filter, now able to use multi select parameter.

But how to make that optional..It should be null by default and report should show all products IDs data

[ppm1]

If you use the query builder it should do it automatically, but please see this article for more information.

Chris Webb's BI Blog: Power BI Report Builder And RSCustomDaxFilter (crossjoin.co.uk)

Pat