Dynamic titles with many filters

[LD1]

Hi, 

I would like to create a dynamic title with all these informations :

- Year = 2022

- Quarter = Quarter 2

- Month = January

I mean, if i have selected 2022 = title = "Turn over 2022"

& if i add Quarter 2 = title = "Turn over 2022 Quarter 2"

& if i add Month January = title = "Turn over 2022 January"

And if all is selected,  title is just "Turn over 2022" whatever you have chosen. 

Can you help me ? 

Thank you,

[v-yanjiang-msft · Accepted solution]

Hi @LD1 ,

According to your description, here's my solution. Create a measure.

title =
"Turn Over" & SELECTEDVALUE ( 'Table'[Year] ) & " "
    & SELECTEDVALUE ( 'Table'[Quarter] ) & " "
    & SELECTEDVALUE ( 'Table'[Month] )

Turn on the visual Title option and select the fx button. 

Select the measure in the fileld dialoge.

Then get the result.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@LD1 , You can use isfiltered to create that

year = if(isfiltered(Table[Year]) , "Turn Over " & selectedvalue(Table[Year]) , "All Years" )

Qtr = if(isfiltered(Table[Year]) , "Turn Over " & selectedvalue(Table[Year])  & " " & if(isfiltered(Table[Qtr]) , "Turn Over " & selectedvalue(Table[Qtr]), "" )  , ""   )

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/