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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Usha_pk
Helper II
Helper II

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

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

Usha_pk_0-1701156859138.png

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

Usha_pk_2-1701156939677.png

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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

Ritaf1983_0-1701157732725.png

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

members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

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

Ritaf1983_0-1701157732725.png

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

members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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

@Usha_pk 
Glad to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors