Forum Discussion
Usha_pk
2 years agoHelper II
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...
- Anonymous2 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.
Idrissshatila
2 years agoSuper User
- Usha_pk2 years agoHelper II
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.