Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AlanP514
Helper V
Helper V

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

1 ACCEPTED SOLUTION
AlanP514
Helper V
Helper V

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

View solution in original post

1 REPLY 1
AlanP514
Helper V
Helper V

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.