Sankey chart

[Anonymous]

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

[v-yingjl · Accepted solution]

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 Li

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

[Anonymous]

@v-yingjl 

Thanks for reply and recommendation!

[amitchandak]

@Anonymous , I think you need to check for some other visual. Sankey is one measure of two dimensions.

[Anonymous]

@amitchandak 

Thanks for reply. 

Any recommendations on potential alternative(s)? 

[amitchandak]

@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

[Anonymous]

@amitchandak 

Thank you so much!