Selectedvalue Dynamic

[AlanP514]

Hai Guys Need your help
I have a year slicer && I want to create a title if the year is not selected the title should show the latest year (2022) otherwise based on the year slicer
For eg: If I select 2022, the title should show  "progress of 2022"
 note. if I didn't select any year the title should show the latest year: "progress of 2022"
If I select any other year the title should show based on the year "progress of 2021"



Thanks
Alan P James

[AlanP514 · Accepted solution]

Title =

VAR _MaxYear = MAX ('Calendar'[Year] )

Var _CurrentYear = YEAR(TODAY())

Var _FinalYear = IF([_Is Year Filtered] = TRUE (),_MaxYear,_CurrentYear)

var final = "Progress Towards Certifications " & " " & UPPER(_FinalYear)

RETURN

final