Show Items with No Data

[Pradeep160]

I am using "Show Items with No Data" option on a Power BI Table visual to show the records for which there is no data. As the table is having a lot of columns, the visual fails to load in the Power BI Service. I am trying to find out if there is any alternate solution to fix this issue. Can anyone suggest solutions to this issue?

[Anonymous · Accepted solution]

Hi @Pradeep160 

1.You can try to use matrix visual instead of table visual, if the value is blank, it will also display in the matrix visual so that you don't need to select 'show item with no value' and this can help imporve the performance of loading.

2.You can consider to add a slicer to the report to filter the table visual to reduce the size of the table visual.

You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/guidance/power-bi-optimization#apply-the-most-restrictive...

Optimization guide for Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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