Forum Discussion
Merge two matrix in one
Hello,
I want to make a merge of two matrix in one single matrix.
My first set of data is shaped like this :
CATEG 1 | CATEG 2 | Value 1
My second set of data is shaped like this :
CATEG 1 | Value 2
I want to make a matrix that looks like this :
| categ 2.1 | categ 2.2 | Total Value 1 | label "Value 2" | |
| categ 1.1 | Value 1 | Value 1 | Value 2 | |
| categ 1.2 | Value 1 | Value 1 | Value 2 | |
| categ 1.3 | Value 1 | Value 1 | Value 2 |
Have you any tips to do that ?
Thanks for your advices.
Hi Khalyda ,
It is not available to achieve that. By default, we add a column/measure into value section in a matrix visual, it will be grouped automatically.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Not very clear but you can merge like this
union( selectcolumns(Table1,"Category1", table1[CATEG 1],"Category2", table1[CATEG 2],"Value", table1[value]), selectcolumns(Table1,"Category1", table1[CATEG 1],"Category2", "","Value", table1[value]) ) 
V-lianl-msftCommunity Support
Hi Khalyda ,
It is not available to achieve that. By default, we add a column/measure into value section in a matrix visual, it will be grouped automatically.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
