Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Hi @triseid ,
The IIF function is a good method. There's a optimization gude for your reference.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.