Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Paginated Report using PBI Dataset - Multi select optional parameter

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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • Anonymous's avatar
    Anonymous
    Not applicable

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