matrix visualization correlation plot

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.⚡

rschaudhr not sure what to say, you have the pbix file and the steps you outlined seem to be the correct one, make sure you have used sort by for your column and picked the correct sort column.

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