cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lsullivan6311
Helper II
Helper II

Dynamic title selected value Table.[YearMo].[Month] & selected value Table.[YearMo].[Year]& prior yr

I have a visual that is filtered based on:

 Table[YearMo].[Month]

 Table[YearMo].[Year]

 

Current dynamic title measure =

 

TitleDetail = "For Twelve Months Ended " & SELECTEDVALUE(Table[YearMo].[Month]) & ", " & SELECTEDVALUE(Table[YearMo].[Year]

which returns:    For Twelve Months Ended December, 2022   (Example for last month)

 

I want it to return:        For Twelve Months Ended December, 2021 and 2022

 

I have made a dynamic title with these two date filters, but how do I include the prior year as well?  There is not a filter for that.

 

1 ACCEPTED SOLUTION
pi_eye
Resolver III
Resolver III

Hi @lsullivan6311 

 

The simplest way would probably be to subtract 1 from the year, and concatenate that into your string.

 

TitleDetail = "For Twelve Months Ended " & SELECTEDVALUE(Table[YearMo].[Month]) & ", " & SELECTEDVALUE(Table[YearMo].[Year])-1 & " and "  & SELECTEDVALUE(Table[YearMo].[Year])

 

Does this work for you?

 

Pi

View solution in original post

1 REPLY 1
pi_eye
Resolver III
Resolver III

Hi @lsullivan6311 

 

The simplest way would probably be to subtract 1 from the year, and concatenate that into your string.

 

TitleDetail = "For Twelve Months Ended " & SELECTEDVALUE(Table[YearMo].[Month]) & ", " & SELECTEDVALUE(Table[YearMo].[Year])-1 & " and "  & SELECTEDVALUE(Table[YearMo].[Year])

 

Does this work for you?

 

Pi

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors