Forum Discussion
Need help in Matrix visual
Hi,
Could someone please help to get the below issue.
Sample data:
| Cat | lable | Gap1 | Gap2 | Pur |
| lable | 1 | 0.25 | 0.12 | 0.19 |
| Gap1 | 0.25 | 1 | 0.24 | 0.49 |
| Gap2 | 0.12 | 0.24 | 1 | 0.46 |
| pur | 0.19 | 0.24 | 0.46 | 1 |
expected output:
| 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 |
Thanks in advance
1 Reply
Rameshu can you explain what you are looking for? I'm not able to understand from your post. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
