Dynamic legend chart based on selected year

[Philsmind]

Hi,

I have a question about the legend of a chart. X-axis is a month column. Y-axis are 2 measures. 1 measure calculates a result for the selection of year 1, the other one for the year selected in the filter Year 2. But I would like to have the legend saying in this example 2021 instead of year 1, and 2022 instead of year 2. So it would have to show the selected year as name in the legend. Would this be possible?

Thanks in advance for helping me out.

[mahenkj2]

Hi @Philsmind ,

If I am understanding your need correctly, just rename the Y axis in the bar chart:

Hope it helps.

[Philsmind]

Hi @mahenkj2 ,

Thank you for your answer. The name has to be dynamic. So if for example when I would change the filter of Year 1 to 2016, the name in the legend should also change in 2016 instead of 'Year 1'.