Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Data filter is not processing in Power BI paginated report visual

Hi Team,   1. While working on Power BI Paginated report ingestion into Power BI file(Ingesting .rdl file into .pbi file) by applying the filter which contains no data. The report is being rendered...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Team,

    I have removed all the slicer visuals in the page and enabled the parameters in the paginated visual. So that the user can apply the filters accordingly in the old fashioned way.

    I found no other way to fix this issue.

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous 

 

 

Given I have so little information at this time, I can't tell what's causing your problem, if possible, please share your pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

 

Here are some steps for your reference:

Ensure that your filter logic is correctly set up to handle cases where no data matches the filter criteria. You might need to adjust the filter expressions to return an empty result set when no data is found

You can use custom code to handle the scenario where no data is returned. For example, you can use expressions like 'FILTER()' in DAX to manage the logic.

Try testing the report with different datasets to see if the issue persists. This can help identify if the problem is specific to certain data or a more general issue.

Double-check the grouping settings for both row and column groups to ensure they are correctly configured.

 

Links for your reference:

Control row & column headings in a Power BI paginated report - Power BI | Microsoft Learn

Solved: Filter Issue with Paginated Report - Microsoft Fabric Community

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.