Forum Discussion

Philsmind's avatar
Philsmind
New Member
3 years ago

Dynamic legend chart based on selected year

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.

 

Need Help

2 Replies

  • mahenkj2's avatar
    mahenkj2
    Solution Sage
    3 years ago

    Hi Philsmind ,

     

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

     

    Hope it helps.

    • Philsmind's avatar
      Philsmind
      New Member
      3 years ago

      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'.