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

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

1 Reply

  • 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