Visual Exceeded The Available Resource?

[itsmebvk]

Hi Folks,

I have created a simple report using a Datset where I have Matrix with couple of dimensions and Measure. This measure will be displayed based on slicer selection. Along with this slicer I have 3 different slicers for country, Saate and City.

 

Everything working fine. I want to highlight only top values from the matrix. For that I craeted a column using Rankx and used it for conditional formatting. When I add this column to conditional formatting I am getting attached error. Do you have any idea how to fix this issue or any work arounds to get only highlight top 5 values in the matrix ( my meaure will be based on slicer).

Please share your inputs.

 

Thanks 

[amitchandak · Accepted solution]

@itsmebvk , In options and setting. clear memory management cache and increase it to 8 to 10 GB. and try this again. Share your measure to check. Run performance analyze and check for bad measure