Forum Discussion

Yael's avatar
Yael
Icon for Helper IV rankHelper IV
9 years ago
Solved

merge identical rows in table visual

Hello,

 

How can I merge identical rows in a table visual?

I want convert from the left table into the right one.

 

 

Thank you!

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI Yael.

     

    Table visual not support to merge the row, I think you can submit this requirement to ideas or use matrix visual.

     

    In addition, if you want to summary the employees which has the similar manger, you can try to use below measure formula.

    Employee Member = 
var manger=LASTNONBLANK(Table1[Manager],[Manager])
return
CALCULATE(CONCATENATEX(VALUES(Table1[Employee]),[Employee],","),Table1[Manager]=manger)

     

    Regard,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    HI Yael.

     

    Table visual not support to merge the row, I think you can submit this requirement to ideas or use matrix visual.

     

    In addition, if you want to summary the employees which has the similar manger, you can try to use below measure formula.

    Employee Member = 
var manger=LASTNONBLANK(Table1[Manager],[Manager])
return
CALCULATE(CONCATENATEX(VALUES(Table1[Employee]),[Employee],","),Table1[Manager]=manger)

     

    Regard,

    Xiaoxin Sheng