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,Sma...
  • 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.