Forum Discussion
Multi-level sankey query - creating supporting visuals
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.
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.
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!
