Forum Discussion

walker4545's avatar
walker4545
Frequent Visitor
4 years ago

Process Data for Chord Diagram using Power Query or DAX

Hello Power BI experts,

 

I am hoping for your assistance with preparing data for use in the custom Chord Diagram in Power BI. For those that are familiar, the diagram typically includes a 'From' column, a 'To' column, and a Gross Amount. 

 

In my particular case, I am wanting to track a user's movement around my website, and have data that looks like the below table:

 

User NameSitepage VisitTime
Joey7HomePage8:00pm
Joey7ProductsPage8:03pm
Greg9HomePage7:44pm
Greg9ShoppingCartPage7:50pm
Greg9ProductsPage7:45pm
Joey7ShoppingCartPage8:04pm
Joey7ComplaintsPage8:10pm
Anna889HomePage6:15pm
Anna889ProductsPage

7:00pm

Anna889ComplaintsPage7:22pm
Gallen32HomePage8:00pm

 

What I would like to do is create a new table within Power BI, that converts the visits into From, To and sum of each for use in the Chord diagram. Eg. How many users visited the ComplaintsPage after they visited the ShoppingCartPage (determined by which Time came first. 

 

If possible, I'd like for this new table to be calculated using a measure so that the chord diagram dynamically updates according to slicers/filters etc. I don't need information on users that visited only one page, or those that went to the same page twice. 

 

In reality my users are in their thousands, as are the types of pages and overall number of rows are millions. 

 

How would I go about processing the data so they are in the correct format for a Chord Diagram? 

 

Any help you could provide would be very much appreciated. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi walker4545 ,

    Please refer to the following blog to see if it helps you.

    Power BI Desktop Interactive chord diagrams 

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.