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 and followed by Summary.

 

Tips and Tricks
Tutorial Requests

2 Replies

  • 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