How to Create a Dimension Selector in Google Looker Studio

Create a Dimension Selector in Google Looker Studio. This simple trick will allow you to build tables that can display your chosen dimensions instead of building a table for every dimension combination.

Link to demo dashboard: https://lookerstudio.google.com/repor...

CASE function:
CASE
WHEN Select a Dimension Parameter = "Session source / medium" THEN Session source / medium
WHEN Select a Dimension Parameter = "Session campaign" THEN Session campaign
WHEN Select a Dimension Parameter = "Page path" THEN Page path
WHEN Select a Dimension Parameter = "Landing page" THEN Landing page
WHEN Select a Dimension Parameter = "Device category" THEN Device category
WHEN Select a Dimension Parameter = "Country" THEN Country
WHEN Select a Dimension Parameter = "Region" THEN Region
ELSE "-"
END

Thank you for watching!