Dynamic Title based on selected values for the multiple selection

[Usha_pk]

Hi Team,

Can you please suggest me how to get the dynamic title based on the slicer selection for the multiple selection

If I select Midmarket, Small Business the title should be "Midmarket,Small Business - Split (KGs)

If I select Channel Partners, Enterprise, Government then title should be "Channel Partners, Enterprise, Government - Split (Tons)

Could you help me on this, Thank you!!

@Ritaf1983 @amitchandak @Greg_Deckler @Idrissshatila @Ahmedx @lbendlin 

[Anonymous · Accepted solution]

Hi @Usha_pk ,

According to your description, here are my steps you can follow as a solution.

(1) We can create a unit table.

Unit = DATATABLE ( 
    "Unit", STRING, 
    {
        { "KGs" },
        { "Tons" }
    }
) 

Then we can create a measure.

Measure = CONCATENATEX('Segment',[Segment],".") & "-" & " Split" &"(" & SELECTEDVALUE('Unit'[Unit]) & ")"

Setting the Conditional Format.

Then the result is as follows.

(2) Or we can create a measure 2. 

Measure 2 = 
var _a= SWITCH(TRUE(),
{"Midmarket"} in VALUES('Segment'[Segment]),"KGs",
{"Small Business"} in VALUES('Segment'[Segment]),"KGs",
{"Channel Partners"} in VALUES('Segment'[Segment]),"Tons",
{"Enterprise"} in VALUES('Segment'[Segment]),"Tons",
{"Government"} in VALUES('Segment'[Segment]),"Tons") 
return  CONCATENATEX('Segment',[Segment],".") & "-" & " Split" &"(" & _a & ")"

Setting the conditional format and selecting [Measure 2].

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[hvnter]

You'll need to make a measure based off of your parameter table.  Try creating variables and calling them in the return of the measure.  I'm using 2 below in my example, but you could get it to do 3 or more with a little creativity. 

Dynamic Title =

var ttl = max('Parameter'[Parameter])

RETURN

IF(ttl="SHOWROOM","SHOWROOM SUMMARY","MARKET SUMMARY")

[Usha_pk]

Can you pls share the same file once, if possible could you ellaborate this. Thank you!

[Idrissshatila]

HEllo @Usha_pk ,

check this https://youtu.be/CqTW9dHsGrM?si=NTVqIkiO1hYgDCWz

[Usha_pk]

Thanks for the video, but my requirement is different from the video. Please help in achieving dynamic title for the multiple selection. The title must be dynamic based on the selected values for the multiple selections.