Dynamic Title

[Anonymous]

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!!

[nvprasad]

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]

@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 · Accepted solution]

@Anonymous , Use single & and try

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