Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Title

Hi,   I want to create a dynamic title based on the selection of 3 different filters namely "Market Segment", "Service Line" and "Country".   Expected Output: When selected any one of the filte...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Use single & and try

     

    Measure  = Selectevalue(slicer1) & "-" & Selectevalue(slicer2) & "-" & Selectevalue(slicer3)

nvprasad's avatar
nvprasad
Solution Sage
5 years ago

Hi,

 

You can create a measure and pass the same in the conditional formatting under the title. Please refer to the below snapshot.

 

Measure can be like = Selectevalue(slicer1) && "-" && Selectevalue(slicer2) &&  "-" && Selectevalue(slicer3)

 

 

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

Anonymous's avatar
Anonymous
Not applicable
5 years ago

nvprasad  Thanks for the formula. Here's the error message that pooped up when i was trying to use it.

 

Error Message:
MdxScript(Model) (44, 65) Calculation error in measure 'Sheet1'[Title]: Cannot convert value '-' of type Text to type True/False.

 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Use single & and try

     

    Measure  = Selectevalue(slicer1) & "-" & Selectevalue(slicer2) & "-" & Selectevalue(slicer3)