Forum Discussion

Robbief's avatar
Robbief
Icon for Helper II rankHelper II
3 years ago
Solved

Chord Chart - Data Preparation

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 c...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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