topic Re: Performance Issues in the Matrix table with field parameter slicers in DAX Commands and Tips

Performance Issues in the Matrix table with field parameter slicers

Piyush_Ghungrud — Thu, 08 Dec 2022 06:26:00 GMT

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.

Re: Performance Issues in the Matrix table with field parameter slicers

amitchandak — Thu, 08 Dec 2022 15:13:24 GMT

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

Re: Performance Issues in the Matrix table with field parameter slicers

Piyush_Ghungrud — Thu, 22 Dec 2022 05:52:11 GMT

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.

Re: Performance Issues in the Matrix table with field parameter slicers

Anonymous — Thu, 29 Dec 2022 08:04:05 GMT

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.