Forum Discussion

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 filters, it should show the selected value and if not, the title should show as "All Market Segments || All Service Lines || All Countries"

Any help on this would be appreciated!!

amitchandak
5 years ago
Anonymous , Use single & and try

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

3 Replies

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
  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
    Super User
    5 years ago
    Anonymous , Use single & and try
    
    Measure = Selectevalue(slicer1) & "-" & Selectevalue(slicer2) & "-" & Selectevalue(slicer3)

Related content