topic Is it possible to use a dynamic value as legend? in DAX Commands and Tips

Is it possible to use a dynamic value as legend?

Anonymous — Fri, 06 Jan 2023 07:59:01 GMT

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

Re: Is it possible to use a dynamic value as legend?

amitchandak — Fri, 06 Jan 2023 12:38:59 GMT

Anonymous , 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

Re: Is it possible to use a dynamic value as legend?

Anonymous — Mon, 09 Jan 2023 09:08:39 GMT

Hi Anonymous ,

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.