Hello,
I am working on a Power BI paginated report of financial data which includes a parameter dropdown list that requires the user to select one or more Project Numbers. The data in the report dataset includes some records in which the Project Number is NULL. Most times, the user will want to select all Project Numbers (including NULLS).
The issue is that Power BI Report Builder does not permit the developer to select both “Allow Null Value” and “Allow Multiple Values” checkboxes in the parameter properties. Does anyone know how to incorporate NULL values in a dropdown list while allowing for multiple values to be selected from that dropdown list (and workable in the overall report)?
I tried IIF to replace them, but due to the amount of data in the dataset, the IF statement broke the resource constraints.
NOTE: The solution needs to be specific to Power BI Report Builder (not Power BI Desktop) as this report needs to be in paginated format so that it can be exported to Excel.
Thank you!
