Mandatory dashboard filter(s)

Feedback and Requests
1

Hello,

New idea : Possibility to "tag" filter(s) as mandatory to have results in the dashboard.

Context:

  • Some Dashboards get a lot of Data if no filter is set.
  • Filter is a business value, not a date, so it's not possible to set a default value.

Feature:
You have to click on "apply filter" button to get the result, the page is not reloaded dynamically when you set a filter.
When you open the dashboard, no result is got.

New%20Project%20(1)
New%20Project%20(1)1500×700 21.9 KB

2

The button will appear if one or more filters are tagged as “mandatory” without default value

3

Hi @bencmoi
If your questions are Native/SQL, then you can set the filters to be Required in the question.
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html
There’s a request for having a “run” button - instead of dynamically updating on each filter change:
https://github.com/metabase/metabase/issues/9871 - upvote by clicking :+1: on the first post

4

Hello @flamber,

Thank you for your response.

Your proposition could work if we had the possibility to choose AND or OR constraint between question filters. But for now, it’s just “AND” condition. (Not in SQL request - in configuration)

Example:
I have 4 required filters. If one (or more) of them is filled, we can get results, not all of them.

5

@bencmoi That would either require giving the option to do Custom Expression filters on the dashboard, or have a rather complex dashboard filter options.
You are welcome open a feature request - keep it to one request per issue, and adding clear description, images and use-case will help a lot.
https://github.com/metabase/metabase/issues/new/choose

EDIT: There's now a request for required/mandatory filters on dashboards:
https://github.com/metabase/metabase/issues/18097 - upvote by clicking :+1: on the first post