Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
7 years ago

Dynamic Title formula

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...
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
RanjanThammaiah
Helper V
7 years ago

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