In a live connection, can i delay the data load until all my slicers are selected?

[renoyzac]

My dashboard is on a live connection. It has some 12 slicers that users can select, but the data it too huge and every slicer selection takes ~5 mins to load the data. So if i've to select 12 slicers that 12 * 5 = 60 mins to load. 
Is there a way where i can delay the refresh till all my slicers are selected? 

[vanessafvg · Accepted solution]

yes you can use query reduction, in the options and settings of power bi you can set the slicers to use an apply button so once all your selection is made, you can change it to use apply for each slicer or one button for all

[renoyzac]

So in my case, out of my 12 i select on 4 slicers. i'll have to click 4 Apply buttons right? won't that be the same thing? 

[vanessafvg]

yes correct.  are you are able to move them to the filer pane at all? then there is one apply button.  I guess you need to balance the user experience to performance.  It looks like there is no perfect solution here.  There might be other ways of managing the issue though by optimising your source for better performance.  For example using materialized views if you have a database on the back end.  Those sorts of things if that is possible and it makes sense to do.

[renoyzac]

hmmm got it. Well it's a troubleshooting dashboard so i need all the slicers for the stakeholders to play around with the data. And yes we're trying to improve the backend server performance. This is a temporary situation for now. Thanks for your help though, at least i can get this implemented. 

[vanessafvg]

in retrospect (because i have never used this function before), i just tested it, and in fact yes each slicer gets an apply button for flexiblity but you can make muliple selections before clicking the apply, so you can make your selections and then when you make your last slicer selection, when you click on that slicers apply  and it will apply all the slicers you changed