Conditional Show/Hide Tables

Looker Q&A Looker
1

I’m working on a Looker Studio report where I have three tables, each created using a custom BigQuery query.

My use case is to display a table only when a specific parameter is set.

Scenario:

  • Table 1 → Always visible
  • Table 2 → Always visible
  • Table 3 → Should only be visible when ShowTable3 = true

For example:

ShowTable3 = false  → Hide Table 3
ShowTable3 = true   → Show Table 3

Currently, I can use the parameter inside the custom query to return no rows, but the table visualization still appears with a “No data” message. What I need is the ability to completely hide or show the chart/table based on a parameter value.

Is there any supported approach to achieve this in Looker Studio?

Thanks,

Sanjiv Shinde

2

Looker Studio does not currently support hiding a chart dynamically based on a report parameter. A parameter can filter the query and return no rows, but the component will still remain visible with “No data.” The practical workarounds are separate pages, overlapping charts controlled through filters, or embedding the report and handling visibility outside Looker Studio. The newer visibility controls are intended for predefined variables such as viewer or group access, rather than arbitrary parameter values.