Forum Discussion
Multi-level sankey query - creating supporting visuals
- 5 years ago
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.
Please provide sample data in usable format (not as a picture) and indicate which Sankey visual you are using.
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!