Forum Discussion

abakes21's avatar
abakes21
Regular Visitor
5 years ago
Solved

Multi-level sankey query - creating supporting visuals

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 withi...
Need Help
  • lbendlin's avatar
    lbendlin
    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.

lbendlin's avatar
lbendlin
Super User
5 years ago

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's avatar
    abakes21
    Regular Visitor
    5 years ago

    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's avatar
      lbendlin
      Super User
      5 years ago

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