Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
Solved

Selectedvalue Dynamic

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 sel...
Need Help
Show and Tell
Tips and Tricks
  • AlanP514's avatar
    AlanP514
    4 years ago
    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
AlanP514's avatar
AlanP514
Post Patron
4 years ago
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