Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hi all, thanks in advance for any help/guidance with this.
I posted before about wanting to track a pathway over time and (wrongly) assumed that simply using the Sankey visualisation I would get what I needed - you can see that post here > https://community.fabric.microsoft.com/t5/Desktop/How-to-chart-changes-over-time-from-one-item-to-an...
I'm having trouble with the summarise function (which I believe is necessary) to give me a three level flow and that I need somehow to make a count of the Via column to do this?
Example data below and I'm keen to chart the volume of A to B to C points to show totals of From flowing into Totals of Via flowing into Totals of To
From | Via | To |
Paris | Amsterdam | Shanghai |
Paris | Frankfurt | Singapore |
Paris | Frankfurt | Singapore |
Paris | Dubai | New York |
Paris | Istanbul | Shanghai |
Paris | Hornbill | Singapore |
Milan | Amsterdam | New York |
Milan | Amsterdam | New York |
Milan | Istanbul | New York |
Milan | Frankfurt | Shanghai |
Milan | Frankfurt | Singapore |
London | Frankfurt | Singapore |
London | Frankfurt | Shanghai |
London | Amsterdam | Singapore |
London | Amsterdam | Shanghai |
The closest I can find on the forum is this post - https://community.fabric.microsoft.com/t5/Desktop/How-to-create-multi-level-sankey-diagram-Sankey-vi... but for the life of me, I can't seem to get it to work..! I keep getting the below type 'map' which isn't as expected. I'm trying to get that 'simple' 3 step flow... Please send help!!
Just to add to this, I have a distinct additional column that would go with this (in this example it could be names of the travellers (all unique))
I'm getting closer to the desired outcome (but still some way to go) so if anyone does have an idea or pointers, these would be greatly received!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
76 | |
74 | |
69 | |
48 | |
40 |
User | Count |
---|---|
61 | |
41 | |
33 | |
30 | |
29 |