Forum Discussion

LPenatti's avatar
LPenatti
Icon for Helper II rankHelper II
7 years ago
Solved

Order By using number in concatenateX

Hi everyone!   I have a chiclet slicer and a card visulization. The card shows what's selected on chiclet slicer (picture 1) To do it I used the following function as a measure: Region_select...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi LPenatti 

    Add "Name" column from "latin map" table  in the slicer, create a measure

    Measure = CONCATENATEX(ALLSELECTED('Table'),'Table'[Name],",",'Table'[Pos])

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi LPenatti 

What final result do you want?

If select map visual "north", the card visul should show "north",

If select map visual "south", the card visul should show "north, brazil,south", right?

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
LPenatti's avatar
LPenatti
Icon for Helper II rankHelper II
7 years ago

Hi v-juanli-msft , thank you for your reply.

 

The result I need is the Card visual shows what's selected in Map Visual filter, in the following order: "North, Brazil, South" (if all regions are selected, of course).

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi LPenatti 

    Add "Name" column from "latin map" table  in the slicer, create a measure

    Measure = CONCATENATEX(ALLSELECTED('Table'),'Table'[Name],",",'Table'[Pos])

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • LPenatti's avatar
      LPenatti
      Icon for Helper II rankHelper II
      7 years ago

      Hi v-juanli-msft, thank you for your response.

       

      It worked like a charm!!! TYVM!

       

      I just added a Calculate function to get only countries with region <> "" because there are some countries with this field in blank in the system...