Does it exist? A table that only populates on command

[Anonymous]

Currently we have a dashboard that is used by our team where they apply approx 8 filters/slicers and the table dynamically changes for them to recieve their desired input.

This table is huge with thousands and thousands of lines, for the team to filter all the way down to only 1 or 2 lines of data

The processing time is massive, is there another option? 

Examples I've thought of in my head but don't know if they exist

1) Table starts empty, first filter/slicer populates table

2) Table starts empty, filters/slicer are selected and then a magical button is pressed and the table populates, like a query table

Hope that makes sense, any solution welcome

[dm-p · Accepted solution]

Hi @Anonymous,

Have you tried enabling Apply buttons for the filter pane in the Query reduction settings? This can greatly reduce  query overhead, i.e.:

Regards,

Daniel

[Nathaniel_C]

Hi @Anonymous ,
Try this: Filter the table to what ever state you wish it to be in on your desktop and then publish it.  When the user opens it up, it will be in that state.  You just have to remind them that in order to get back to the published state, there is a left pointing circular arrow in the upper right corner. If they have it filtered in a different fashion, when the browser is closed, it should open with that state the next time.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel