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.

     

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

Hi sturlaws, thanks for your reply.

I forgot to mention it, but yes, 'Latin America Map'[Name] was already sort by 'Latin America Map'[Pos]

sturlaws's avatar
sturlaws
Icon for Resident Rockstar rankResident Rockstar
7 years ago

and you used the Sort by column-function to do this?

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

    Hi sturlaws, yes I've sorted by this function.