Column chart series label change according to filters apply

Looker Q&A Looker
, , ,
1

Hi everyone, I’m new to Looker, and I need to modify a dashboard in the following way:

At the moment, I have a visualization tile representing previous year data (revenue prior year to the selected year) and current year data (revenue for the selected year).

What I need to achieve is for the series labels to dynamically update based on the Year filter. Currently, the labels show “Revenue (prior year to selected)” and “Revenue (selected year).” I want these labels to automatically update to show the specific years, like “Revenue 2023” and “Revenue 2024,” when I select a year in the filter. Is there a way to do this without any code changes, or can you suggest a solution?

kanchan09_0-1720715800655.png
kanchan09_0-1720715800655.png1606×621 23 KB

expected after applying filter year -

kanchan09_1-1720715915803.png
kanchan09_1-1720715915803.png1430×507 13.8 KB

Thanks

1 Like
2

You can achieve this by using liquid in label.

Here’s the link:

Interesting ways to use Liquid in labels | Looker | Google Cloud

How to use Liquid to format dates | Looker | Google Cloud

Liquid variable reference | Looker | Google Cloud

3

Hi,

I have tried to make changes using Liquid format but that labels should be change according to filter but I am not able to achieve this. suggest me any other option if have?