Forum Discussion
Helper IPerformance Issues in the Matrix table with field parameter slicers
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.
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.
3 Replies
- amitchandak
Super User
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_Ghungrudamitchandak, 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.
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.
