Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Multi Value Matrix

I am trying to create a matrix that mimics this excel sheet. It has multiple items that fall in the intersection of two criteria(date and model).  PowerBI only easily lets you show the first, last, or count of these values. Is there a way to show all values in a table? 

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

    Create a new measure and add that to matrix visual value

    Routing ID on row and month year and Column

     

    Concatenatex(Table,Table[Work ID], unichar(10))

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You can use concatenatex and use all values

     

    concatenate(Table, Table[Column], unichar(10)) 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    i am relatively new so either i dont quite understand or should be more specific. I have the below table, and if a "workID" has the same "RoutingID" and same month in "start_cur" as any other "WorkID", i need to concatenate the WorkIDs to be in the same cell. 

     

    • amitchandak's avatar
      amitchandak
      Super User
      4 years ago

      Anonymous ,

      Create a new measure and add that to matrix visual value

      Routing ID on row and month year and Column

       

      Concatenatex(Table,Table[Work ID], unichar(10))