Chord Chart - Data Preparation

[Robbief]

I would love to use the chord chart to analyse how people are interacting.  

Essentially, I have two tables:

One Showing Individual Thank You's (Initiated by Employees) giving thanks  (1 Employee can give 1 Thanks at a time)

The other are for those being thanked (1 Thank you from 1 employee could result in 5 other employees being thanked)

I would like to use the chord chart to corrilate the relationship between thanks sending thanks, and those recieving thanks.  I understand that to do this, I need a simple table of:

Those Thanking / Whome is Getting Thanked / How Often this Unique Combination is Occuring

This is where I am stuck.........    I assume I will need to create a calculated table (Or Maybe better in M Query), but I'm not sure how I go about creating the table, or even what to google  (I've tried to no avail).  Essentially I need some kind of unique combination for every persons relationship whether thanking or being thanked (But in two seperate Columns), and then I need to count how often this occurs in the data, and write the value in the 3rd Column.....

Could someone give me some hints as to how I might build this,?

Thanks 

Robbie

[Anonymous · Accepted solution]

Hi @Robbief,

So you mean you are not clear on how to design the root table that is used and analyze on the chord chart? If that is the case, the basic table can be used on chord only required three fields, 'from', 'to', and 'value'. You can try to expand and summary your table records to these feilds.

In addition, you can also take a look at the following blog about using chord chart if helps:

Power BI Desktop Interactive chord diagrams (sqlshack.com)

Regards,

Xiaoxin Sheng