Multi-level sankey query - creating supporting visuals

[abakes21]

Hi Power Bi Community,

This is my first go at Power Bi and I'm creating a multi-level sankey for our customer journey.

I'm trying to create supporting visuals that can tell more of a story within the sankey (eg. when a node is clicked within the sankey a table is updated that has more qualitative information). However, because a multi-level sankey is created through a new table. I've lost the connection to the original table and can't figure out how to re-connect to the original table.

Any help would be greatly appreciated!

All the best,

Andrew 

[lbendlin · Accepted solution]

This is how far I got for now.  As mentioned I added an index column in power Query. However it looks like the Sankey visual does not support drillthrough, so for now your only option is to right click, show as table.

You can consider these options:

- Add the field name (or an abbreviated version) as a prefix to the field values

- tell your story the other way round - have the raw data table drive the Sankey.

- raise an issue with the developer Issues · microsoft/powerbi-visuals-sankey · GitHub

- clone the visual code and modify it yourself.

[abakes21]

I thought the drillthrough would have been the answer, but it's good to know that the Sankey visual doesn't support it. I will contact the developer and see if something can be done.

In the mean time, telling my story the other way around as you suggested may be the way to go.

I really appreciate your help - Thanks again!

[lbendlin]

Add an index of the original table's row to the UNION.  You don't need to display it directly in the Sankey but you can use it for the drillthrough.

[abakes21]

Thank you for the response!

It makes sense, but I have no idea how to add an index. I've spent the last couple of hours trying to sort it out but, I'm struggling.

Any chance you can elaborate on the solution a little bit more?

Thanks again!

[lbendlin]

Please provide sample data in usable format (not as a picture) and indicate which Sankey visual you are using.

[abakes21]

Hi IbendIin,

I really appreciate the response!

I've added a sample of original data:

https://docs.google.com/spreadsheets/d/1RaQDkUG8qHh_nxtUM58Xx2Qm7GEfprAOlaZTGg8a3jE/edit?usp=sharing

Im not sure if this answers the second part of your question, but Im using Sankey Chart version 3.0.3. 

If you need any other information from please please let me know. And thanks again for your help!