How to get the corresponding dynamic title based on the year selection

[Usha_pk]

Hi team,
@Greg_Deckler @amitchandak @Ritaf1983 @johnt75 @PaulDBrown @sevenhills @Ahmedx 
I'm working on requirement where it has two years year1 and year2

Now if I select year 2023, then the corresponding year2 will appear i.e., 2023,2024,2025,2026,2027.

So my requriement is like, for example If I select 2023 in year1 slicer then my title should change dynamically based on year2. In short my dyamic title for the visual should be "Assumption years are 2023-2027"

Can anyone helpme out with this. Thanks a lot!!

[Ritaf1983 · Accepted solution]

Hi @Usha_pk 
You can create a measure 
Title = "Assumption years are "  & min('year1'([year])) & "-" & max('year2'[year]))

and put it on the title with conditional formatting

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

[Usha_pk]

@Ritaf1983 Thank you, It helped to solve my issue.

[Ritaf1983]

@Usha_pk 
Glad to help 🙂