Filter column on a table based on Direct query

Hello @jgrueso

When using Direct Query, every time a filter is applied, the dashboard makes a new query to the underlying data source. This is likely why your filters aren’t working as expected, they are trying to retrieve new data rather than filtering the already displayed results.

If possible Switch to SPICE, load the dataset into SPICE. When using SPICE, filters applied after the initial load do not trigger additional queries to the database but filter the already loaded data.

Hope this helps!

1 Like