Forum Discussion
Paginated Report returns no results if a parameter null checkbox is checked
Hi Guys,
I Wase creating a paginated report with only one filter. My requirement is that if i didnt select anything in the filter it should return all rectods. But unfortunately it is returning no results even if i select NULL checkbox as well.
2 Replies
- v-janeyg-msft
Community Support
Hi, wshahzad
According to your description, Have you set the default value of the parameter? Can you show me more datails about it?
Here are some videos and documents for reference:
Power BI Paginated Reports in a Day - 11: Working with Parameters - Part 1 - YouTube
Power BI Paginated Reports Part 10 - Get Started with Parameters - YouTube
Report parameters in Power BI Report Builder - Power BI | Microsoft Docs
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mohammedadnant
Impactful Individual
Hi wshahzad
Try add the following the parameter properties,
default values --> Get values from query --> select the dataset and column
so, by default it will load all the values, if user didn't select anything.
Thanks & Regards,
Mohammed Adnan
