Forum Discussion
Usha_pk
Helper II
2 years agoDynamic 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
Super User
2 years ago- Usha_pk2 years ago
Helper 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.