How to implement dynamic field selection in Looker (multi-select dimensions/measures)?

Looker Q&A Looker
, , ,
1

I’m trying to implement dynamic field selection in Looker.

Requirement:

  • Users should be able to select one or more dimensions and/or measures

  • Based on the selection, the table or visualization should update dynamically

What I tried:

  • Parameters → works only for single selection

  • Filter-based dynamic dimensions → allows multiple selections but requires creating many separate fields

Issue:

  • I’m not able to dynamically change the query structure based on user selection

  • Current approaches feel limited and not fully dynamic

Questions:

  • Is dynamic multi-field selection supported natively in Looker?

  • What is the recommended approach for this use case?

  • Can this be achieved using LookML only, or is a custom extension required?

Environment:

  • Database: BigQuery

  • Using LookML and dashboards

Thanks in advance!