Performance Issues in the Matrix table with field parameter slicers

[Piyush_Ghungrud]

Hi Community, 

I have worked on the Matrix table where I wanted to display two field parameter slicers. I was able to implement the slicers and done with creating the desired matrix however when all the selections in both the slicers are selected I get a performance issue for a long time. 

Please, let me know if there is anything to be done to increase the performance of the matrix.

Thank you.

[Anonymous · Accepted solution]

Hi @Piyush_Ghungrud ,

Matrix visuals are slow due to data model errors and poor measure performance. Your solution is to properly design your data model and optimize the performance of your calculations.

Please refer to the following document for more information.

running out of resources - Microsoft Power BI Community

Why my Power BI Matrix or Table Visual is SLOW - RADACAD

Performance Tuning DAX - Part 1 - Microsoft Power BI Community

Best Regards,

Neeko Tang

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

[amitchandak]

@Piyush_Ghungrud , if you create the same visual without using the parameter slicer, is it working better?

If yes, then log and issue at - https://community.powerbi.com/t5/Issues/idb-p/Issues

[Piyush_Ghungrud]

@amitchandak, I have tried creating another table without a slicer, the matrix is getting loaded faster but it is not showing all the values that are in there. Since there is no slicer, it should show all values but it is not.