Memory problem when using a Matrix

[Frenchtom811]

Hi folks!  I am using a matrix to display gross margin % (a calculated measure) by quarter for the top N number of products ranked by total revenue.  N is a user selected value between 1 and 25.  I am getting the following error on the matrix when trying to display the above information.  When I change the matrix to a table of any other kind of visual I do not get the memory problem although choosing a table as the visual requires about 20 seconds to refresh.   

How can I make the Matrix work for me or reduce the memory required to poulate it?  I have already minimized my data table as much as possible.

Thanks!

[v-kkf-msft]

Hi @Frenchtom811 ,

Could you please share your PBIX file without sensitive data? Because it may have something to do with your model or the measures you created.

Best Regards,
Winniz

[mattww]

Hi @Frenchtom811, are you able to screenshot your data model? What's the size of the table involved in columns/rows?

[Frenchtom811]

Hi @mattw , do you mean a screen grab of the dashboard?  If yes I can do that but I need to hide proprietary info first.

[mattww]

Hi @Frenchtom811 , yeah that's fair enough about your data privacy. The more information you can safely give, the better as the issue you're encountering can be very specific to each data model and source.