Forum Discussion
jayasurya_prud
4 years agoAdvocate III
optional Parameter - Paginated report
I am building a Paginated report in Power Bi report Builder. I am adding the Parameters for the report directly in Query Designer and by the Hierarchy.
I want to make my Parameters Optional. Which means, the user is not supposed to select or give values for all the parameters.
Lets assume that We have 30 Parameters. And it should be enough if my user clicks very few Parameters and not all 30 parameters. And the report should be generated even if not all the parameters are not slected.
Please help me with this.
1 Reply
- FarhanAhmedCommunity Champion
check "Allow Null Values" in parameters property