How to add Dashboard filter selection to text tile?

Looker Q&A Looker
1

Have a dashboard with multiple filters.

Would like to include a text tile as a “header” for the dashboard that includes the filter selection text

i.e. “Dashboard for company: filter1” where filter1 is selected via the dashboard filter

2

Hi Meikev,

It’s not possible to dynamically change a text tile, but it can be done using a dimension and html.

As an example, let’s say you have a dimension brand which is a filter in your dashboard. You can create a new dimension title, which is the brand dimension with html formatting.

dimension: title {
    type: string
    sql: ${brand} ;;
    html: <h1>Dashboard: {{rendered_value}}</h1> ;;
  }

By creating a Single Value visualisation and applying the brand filter in the dashboard, you’ll have your own dynamic title.

Hope this helps

Naomi

3 Likes