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.
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.