Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a table like below and trying to create a sankey diagram using the free version.
Customer | Status | Date | applicatoin no | product | Before | After |
1 | in | 1/1/2024 | 1 | C | No | D |
1 | in | 1/2/2024 | 2 | D | C | No |
2 | out | 1/3/2024 | 3 | J | No | C |
2 | out | 1/4/2024 | 4 | C | J | M |
2 | out | 1/5/2024 | 5 | M | C | No |
3 | in | 1/6/2024 | 6 | C | No | L |
4 | in | 1/7/2024 | 7 | L | No | C |
4 | in | 1/8/2024 | 8 | C | L | No |
In the sankey, I want to show the before->product->after sequence for each customer where product = "C" (highlighted). So its like souce-Before, middle-C, destination-After. Can you please help me create the data table for this. Thanks.
Sorry for the delayed response. I think the previous image wasn't clear. My actual dataset is too large and the names are long. So printing it in the middle is a bit cluttered. Can we make a similar Sankey?
Thanks for this. It works. But below is what I exactly wanted. I hope you can understand the drawing.
Customer | Before | Product | After |
1 | R | C | No |
2 | A | C | J |
3 | No | C | D |
4 | A | C | J |
5 | B | C | K |
6 | B | C | K |
Thanks for this. Yes, it works. But what exactly I wanted is the below. I just did a drawing. Hope you can understand it.
Customer | Before | Product | After |
1 | R | C | No |
2 | A | C | J |
3 | No | C | D |
4 | A | C | J |
5 | B | C | K |
6 | B | C | K |
Hi @temptester ,
According to the field information provided by Sankey visual, the best way to show this effect is to enable data link labels.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @temptester ,
You need to put the product field into source labels, and then turn on date link labels in the data format.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
8 | |
8 | |
6 | |
5 |
User | Count |
---|---|
17 | |
14 | |
10 | |
9 | |
8 |