Latest Enterprise DNA Initiatives

Perf issue using multiple slider filters on multiple visuals

Hello!

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?

Maybe you need to go directly to the Microsoft Power BI Team Support for this.

Could you have the data grouped together up streamed before going into power bi and filter on one filter instead of using multiple filters? (have your IT team do it)

Likely its just a lot of trail and error procedures that you need to do to figure it out what its faster.

Those are the steps I would try.

thanks
Keith

Hello @_mk7 , good to see that you are having progress with your inquiry. Did the response from @Keith help you solve your inquiry?

If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

Hi @_mk7, we’ve noticed that no response has been received from you since Sep 13.

We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.