Filter Issue with Paginated Report
The paginated report, Issue. I need help with the power BI paginated report for user requirements. I have 6 parameters that are to be filtered on the report. Order No, Customer, Material No, MLFB, GG, and Sales Office. Problem statement:- User can select any filter whichever wants. Example 1 ) User can select Order No and Customer and keep other filters as blank Example 2) User can select MLFB, Customer, and Sales Office and keep other filters blank He can select any of the filters he wants. Each of the filters is binded to master records that are individual data sets. The user does not want to cascade the filters. Outcome required:- By selecting the filters which the user wants, a report has to be generated which will have the records having the value selected in the filters. Issue Faced:-When any of the filters are kept blank, blank data is loaded onto the page. Ideally, it should have loaded the data according to the filters which are selected. In paginated since the filter work in 'AND', I am not sure how to achieve this requirement. Any help will be appreciated...
