Forum Discussion

lwall_mba's avatar
lwall_mba
New Member
9 years ago
Solved

How Do You Build This? Is it Sankey?

Hello all - I have been trying to create this in Power BI, see picture attached. 

 

https://drive.google.com/open?id=0B3TWgPuEn9sYNlFHV1ZlOFJUdW8

 

How Do You Build This in Power BI?

 

All Sankey charts I used, failed because they don't automatically group categories by month (t, t+1, t+2, etc.).

 

I want the boxes to change sizes depending on the number assigned to those labels.

 

Also, the size of the arrows connecting the boxes should have the size of the numbers departing one label and connecting to other. 

 

Another important aspect is that not every label gets an output/destination. See mainly the top ones.

 

If this is possible with a Sankey diagram, how does the data have to look like?

  • lwall_mba

     

    If you want to change the size based on associated labels, you can try the custom visual Sankey with Labels. But you have to keep t+1 connecting either side. If item in t+1 hasn't connected any side, it will not be displayed. 

     

    Regards

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    lwall_mba

     

    If you want to change the size based on associated labels, you can try the custom visual Sankey with Labels. But you have to keep t+1 connecting either side. If item in t+1 hasn't connected any side, it will not be displayed. 

     

    Regards

    • fclbri's avatar
      fclbri
      New Member

      Hi, I have used Sankey with Labels well but I cannot get the .pbiviz files anymore. if you do not mind, could you send me the file to my email? my email is [email protected]