Forum Discussion
matrix visualization correlation plot
I am trying to create the following visual
However, when I am using matrix visualization I get the following:
Does someone have any suggestions.
Thanks!
The raw data is shown below:
| Fact_1 | Fact_2 | Sum of VALUE_ |
| CM | CM | 1 |
| Direct | Direct | 1 |
| fund | fund | 1 |
| DM | DM | 1 |
| QR | QR | 1 |
| GE | GE | 1 |
| HF | HF | 1 |
| ils | ils | 1 |
| mkt | mkt | 1 |
| debt | debt | 1 |
| HF | mkt | 0.82 |
| fund | mkt | 0.74 |
| QR | mkt | 0.71 |
| ils | mkt | 0.68 |
| HF | ils | 0.67 |
| HF | QR | 0.66 |
| QR | CM | 0.61 |
| CM | mkt | 0.61 |
| DM | mkt | 0.59 |
| HF | CM | 0.58 |
| HF | fund | 0.57 |
| QR | ils | 0.57 |
| CM | ils | 0.54 |
| fund | ils | 0.53 |
| Direct | mkt | 0.53 |
| HF | DM | 0.5 |
| DM | QR | 0.48 |
| fund | QR | 0.47 |
| fund | CM | 0.44 |
| Direct | ils | 0.43 |
| GE | mkt | 0.42 |
| Direct | fund | 0.38 |
| fund | DM | 0.37 |
| Direct | CM | 0.35 |
| DM | CM | 0.33 |
| Direct | QR | 0.32 |
| HF | Direct | 0.3 |
| DM | ils | 0.26 |
| HF | GE | 0.13 |
| GE | ils | 0.11 |
| GE | DM | 0.08 |
| GE | Direct | 0.07 |
| Direct | DM | 0.04 |
| QR | debt | 0.04 |
| GE | CM | 0.03 |
| GE | QR | 0.03 |
| HF | debt | 0.02 |
| CM | debt | 0.01 |
| ils | debt | 0 |
| DM | debt | 0 |
| GE | fund | 0 |
| Direct | debt | 0 |
| debt | mkt | 0 |
| fund | debt | -0.01 |
| GE | debt | -0.03 |
rschaudhr also to make sure matrix visual is also sorted correctly:
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi rschaudhr,
As a side note, did you apply fact1_sort and fact2_sort to fact_1 and fact_2 respectively?
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
v-xulin-mstf and parry2k ,
Yes, I had applied sort order properly and it did not work.
However, I found the missing step and that is at the time you create fact_1_sort and fact_2_sort in the transform section. You have to do the group by to create the sort order. I actually added a column in transformation with sort order. The group by is the critical step for this visual. Once it was applied, it worked a like a charm.
I will accept this as a solution.
Thank you
7 Replies
rschaudhr solution attached, change as you see fit.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k ,
Thank you for the solution.
I am still have an issue getting the visual in the format show above. I followed through your steps.
First create two columns for sort in Transform Data. One is called Tabe Fact 1 and the other one is called Table Fact 2. Create a sort order is opposite direction. So, HF is sort order of 10 in Table Fact 1 and it will be sort order of 1 in Table Fact 2.
Second step is to merge Fact 1 and Fact 2 to the Table and only bring back sort order for each of Table Fact.
Third step is set sort by column. So, for Fact_2 will be sort order by Fact2 Sort and Fact_1 will be sort order by Fact1 Sort.
Forth step is to create the matrix visual. with Fact_1, Fact_2 and Values.
Is there any other steps that needed to be taken?
rschaudhr also to make sure matrix visual is also sorted correctly:
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi rschaudhr,
As a side note, did you apply fact1_sort and fact2_sort to fact_1 and fact_2 respectively?
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
v-xulin-mstf and parry2k ,
Yes, I had applied sort order properly and it did not work.
However, I found the missing step and that is at the time you create fact_1_sort and fact_2_sort in the transform section. You have to do the group by to create the sort order. I actually added a column in transformation with sort order. The group by is the critical step for this visual. Once it was applied, it worked a like a charm.
I will accept this as a solution.
Thank you