Dynamic Title formula

[RanjanThammaiah]

Hi All,

Can some one help me with the below Dynamic title formula.

I want the title to be shown as"FY19 Declined/Lost Summary"

When i select the Slicer below it should be FY19 Slicer name and followed by Summary.

[Anonymous]

@RanjanThammaiah -

This should work - the "HASONEVALUE" part just adds a space if there is only one value. You may not need that if a single value is guaranteed.

Outcome Filter = 
"FY 19 " 
& SELECTEDVALUE (Sheet1[Outcome])  
& IF(HASONEVALUE(Sheet1[Outcome]), " ", "") 
& "Outcome"

Hope this helps,

Nathan

[RanjanThammaiah]

Hi,

Thanks for the Formula. Life saver.

I have a slicer with "Declined" and "Lost", So if i select the One i am able to get the header as per the requirement.

i.e FY "19 Lost Summary "or "FY19 Declined Summary".

If i select the Both the result will be "FY19 Summary", So the problem creates here, If i select both i wanted to show the title as "FY19 Outcome Summay", Is this something easily achievable?

Outcome Filter =

"FY 19 "

& SELECTEDVALUE (Sheet1[Outcome])

& IF(HASONEVALUE(Sheet1[Outcome]), " ", "")

& "Summary"

Thank you so much again for your help.

Regards,

Ranjan