Is it possible to use a dynamic value as legend?

[ovonel]

I have my clustered column chart working just fine, with Rev and Rev SamePeriodLastYear.

Measures:

(Rev is just a sum… and the other measure uses the function SAMEPERIODLASTYEAR.)

In my report I use the YEAR filter:

It works fine, my issue is with my legends:

I want to see as legend; 2023 2022 (when 2023 is selected) and 2022 2021 (when 2022 is selected). (or at least static/generic like "selected year" "previous year")

Is this even possible? The legend section doesn't have a 'function' option to make it dynamic

[v-rzhou-msft · Accepted solution]

Hi @ovonel ,

Here I create a sample to have a test. In my sample, data is from 2020/01/01 to 2023/01/09. I suggest you to create an unrelated DimYear table to create the slicer. My data model is as below.

Measure:

Rev = 
VAR _SELECT =
    SELECTEDVALUE ( SelectYear[Year] )
RETURN
    IF (
        SELECTEDVALUE ( DimDate[Year] )
            IN { _SELECT, _SELECT - 1 },
        SUM ( 'Table'[Value] )
    )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ovonel , I doubt rename measure dynamically, What You can try is have a slicer on an independent table

try like

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Year])
var _min = _max -1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Year] >=_min && 'Date'[Year] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI