Forum Discussion

negbc's avatar
negbc
Icon for Helper II rankHelper II
2 years ago
Solved

Visual exceeds available Resources with Blank Table Filter

I'm having an issue where the table visual data exceedes the available resources, so as a workaround I wanted to use the measure to keep the table blank until an option is selected by the filter (see below for code). However, I still get the available resources error when nothing is selected. Is there another solution I can try or is the only option to reduce the number of columns in the table?

 

Filtered Table =
CALCULATE(
    IF(ISFILTERED('Detail Report'[Contract #]), 1, 0), ALLSELECTED('Detail Report')
)
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi negbc 

    If it is happening in Power BI Desktop file,
    Can you please clear catch and try again
    Please check if your C drive is full or not


     

    If use the default slicer, for example, if you have  10 country of data in Matrix Visual. Create a Country filter and one Country as default. Just idea, so it will load faster and users can change silcer and see report.

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS 


    Thanks
    Pijush



1 Reply

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi negbc 

    If it is happening in Power BI Desktop file,
    Can you please clear catch and try again
    Please check if your C drive is full or not


     

    If use the default slicer, for example, if you have  10 country of data in Matrix Visual. Create a Country filter and one Country as default. Just idea, so it will load faster and users can change silcer and see report.

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS 


    Thanks
    Pijush