Column chart series label change according to filters apply

[kanchan09]

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?

expected after applying filter year -

Thanks

[salehaxsid]

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

[kanchan09]

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?