Visual trying to display all my data despite its filtered by measure

[varelapablo90]

Hello community

I am having the bellow issue with a table visual that I dont want anything to be displayed until the user inputs specific information in the report.

For this reason I've done a measure to indicate when and when not to display information.

Despite the measure works fine, when nothing is selected it loooks as it tries to load all data into the report, can this be fixed somehow? 

Image 1

Image 2 (Doing only one selection) this is how I would expect to see the table when no Company and Vendor are selected (an empty table)

Image 3 when everthing is correct.

[v-yiruan-msft · Accepted solution]

Hi @varelapablo90 ,

The issue in Image 1 occurs when a visual attempts to query too much data for the server to complete the result with the available resources. You can refer the method in the following links to solve your problem:

Troubleshooting tile errors - Power BI | Microsoft Learn

The visual has tried to query too much data for Power BI to complete the result with available resources. Try filtering the visual to reduce the amount of data in the result.

---

The “Visual Has Exceeded The Available Resources” Error In Power BI - Chris Webb's BI Blog

In addition, please review the following links to optimize your model and check which measure or other objects takes up too many resources...

Optimization:

Power BI Performance Tips and Techniques

Data Import Best Practices in Power BI

Performance Analyzer: 

Use Performance Analyzer to examine report element performance in Power BI Desktop

Best Regards