Forum Discussion
Sankey chart
Hi dear community,
I have a situation where I need to vizualize marketing spending and revenue data. The input table looks like this:
| Channel | Spending | % Spending | Revenue | % Revenue |
| FB | 100 | 0.2 | 150 | 0.17 |
| Gads | 50 | 0.1 | 150 | 0.17 |
| Offline | 150 | 0.3 | 200 | 0.22 |
| TvAds | 200 | 0.4 | 400 | 0.44 |
So you can see thar share of spendings per channel for given period and respective revenue. My goal is to create a Sankey chart vizulization where I can link the share of spending to respective share of revenue.
I have chacked the custom viz. but ir seems it works only with one measure.
What could be the workaround here ? Any advice/best practice you can share?
Many thanks in advance.
Cheers,
Saro
Hi Anonymous ,
You can try to use 'Tornado 2.1.0' custom chart to have an obvious contrast of spend and revenue:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
Anonymous , I think you need to check for some other visual. Sankey is one measure of two dimensions.
Anonymous , double donut, would have been ideal. But did not found that
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380858?tab=Overview
I tried one by overlapping pie and donut. Need lot of work
Hi Anonymous ,
You can try to use 'Tornado 2.1.0' custom chart to have an obvious contrast of spend and revenue:
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for reply and recommendation!
For visualizing marketing spending and revenue data in a Sankey diagram, I recommend the Sankey Diagram by VisioChart. I've tried many visuals, and this one is among the best, with great features and good support at an affordable price.
Hi,
I was going through the questions regarding multi-level data visualizations and check this thread. Someone has answered the question. There are options in the store now to choose the chart from, a few are mentioned here and a few are missing, one of those is Sankey Diagram by ChartExpo easy data format and rich set of properties to customize the chart will help you make the chart as per your need.
The following playlist will help you to explore how to videos:
https://www.youtube.com/playlist?list=PLG5ONdnoR4TKBL9woafVVwO1VGtZFVz_b
The best example to make income statement chart is attached here:
Thanks,
Talib
