Forum Discussion
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
- ppm1Solution Sage
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
- AnonymousNot 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
- AnonymousNot 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