Forum Discussion
Need help to get column and Row values in Matrix
Hi,
Could you some please help with below query.
Sample data:
| Categ | Lable | Gap2 | Gap1 | pur |
| Lable | 1 | 0.124 | 0.2513 | 0.19 |
| Gap2 | 0.124 | 1 | 0.249 | 0.46 |
| Gap1 | 0.25 | 0.49 | 1 | 0.56 |
| pur | 0.19 | 0.46 | 0.49 | 1 |
Expected Output:
| Cat | GAP1 | GAP2 | lable | Pur |
| GAP1 | 1 | 0.24 | 0.64 | 0.49 |
| GAP2 | 0.24 | 1 | 0.75 | 0.46 |
| lable | 0.21 | 0.10 | 1 | 0.16 |
| Pur | 0.49 | 0.46 | 0.16 | 1 |
1 Reply
- amitchandak
Super User
Rameshu , for Categ column you need sort column to change the order. The other are columns, you can chnage the position
new column
Categ 1= [Categ]
Categ Sort = Switch([Categ],
"GAP1",1,
"GAP2",2,
"lable",3,
"Pur",4,5)
Select Categ 1 column and from column, tools mark Categ Sort as a sort column and use Categ 1 in visual
PowerBI Abstract Thesis Episode 6: How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
