Forum Discussion

Usha_pk's avatar
Usha_pk
Helper II
2 years ago
Solved

Dynamic Title based on selected values for the multiple selection

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 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

5 Replies

    • Usha_pk's avatar
      Usha_pk
      Helper II
      2 years ago

      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.

  • hvnter's avatar
    hvnter
    Resolver I
    2 years ago

    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's avatar
      Usha_pk
      Helper II
      2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.