cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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

1 ACCEPTED SOLUTION

@Mahesh_Gupta , Use single & and try

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

3 REPLIES 3
Resolver IV
Resolver IV

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)

 

 

nvprasad_0-1604321687848.png

 

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

Regards,
N V Durga Prasad

@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.

 

@Mahesh_Gupta , Use single & and try

 

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors