I have a report where we’re attempting to use two slider slicers to limit the results returned in multiple visuals. I’m achieving this by creating measures using the slider values as FILTER conditions, then applying a visual level filter on the visuals to filter out data where BLANK is returned.
This approach works on smaller datasets, however, when I’m going against full volume (~300M rows in fact table), I’m hitting per-query resource limit exceeded (Premium Capacity P1 SKU, 6GB default limit).
Here’s an earlier thread I posted describing the problem and including a smaller sample dataset.
Per @AntrikshSharma feedback, it looks like the problem lies in the usage of the measures within the filter pane. In addition, the Min Total Sales (ITEM) measure appears to be resource intensive.
Is there a recommended alternative approach for applying multiple slider filters to multiple visuals that would be less resource intensive?