Data filter is not processing in Power BI paginated report visual

[Chandra_Sadan]

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.

2. While working on Power BI Paginated report ingestion into Power BI file(Ingesting .rdl file into .pbi file) by applying the filter I am getting the data but after getting the data if I select the filters which contains no data, then nothing is happening like it is showing the same data as before. Here I want to show a blank table with headers only.

Any suggestion would help.

Note: I have applied the grouping on row level and column level as well.

[Chandra_Sadan · Accepted solution]

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.

[Poojara_D12]

Hi @Chandra_Sadan 

To show a blank table with headers when no data is returned from a filter in Power BI Paginated Reports:

1. Show Blank Table:

   • In the Visibility property of the table, ensure it is set to always show, even when no data is returned.
   • Use an expression like =IIF(CountRows("DataSet") = 0, "No Data Available", "") to display a message when no data is available.

2. Filters with No Data:

   • Ensure filters are properly configured to trigger a refresh and show blank rows if no data is found.
   • Use expressions to clear or hide data when no rows are returned: =IIF(CountRows("DataSet") = 0, Nothing, Fields!YourField.Value).

3. Grouping:

   • Check grouping logic to ensure it doesn't hide blank rows when no data is returned.

These adjustments should allow you to display a blank table with headers when no data is found for a filter.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[v-zhengdxu-msft]

Hi @Chandra_Sadan 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

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.

[v-zhengdxu-msft]

Hi @Chandra_Sadan 

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.