Forum Discussion
Dynamic Title based on selected values for the multiple selection
- 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.
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.
Can you pls share the same file once, if possible could you ellaborate this. Thank you!