Forum Discussion
visual exceeds available resources
My visual is fine at first but when I start clicking on the + to expand the data then the visual exceeds available resources. The last column is a huge measure which is causing the issue. The m...
So if I filter the months to just May June and July, the visual works. It only crashes when I try to add August (current month's data). Do you know why this is?
As you have not shared your model, or some minimum representative data, a recommendation would be to sit down with the measures and data sources to determine what has become costly, and why. Tools to help would be DAX Studio, Tablular Editor, and Measure Killer. It sounds as if you need to break it down and profile all aspects. I would be open with your leadership as you need to explain this in plain language if needed. Blanket answers like "I hate slicers" can be worked around.
Brainstorming: If you query August (or same month) values alone, does the visual hang up?