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