Sankey chart

[Elmarius123]

How can i show with sankey graph a movement within the same cathegory between 2 days? Suppose, on day T, loan was at late day count 30, so it is in bucket "1-30", but on T+1, late day count is 31. So now it is in bucket "31-60".  I want to show transformation of my loan portfolio within buckets during 2 days.. thank you.a

 

[ppm1]

This is probably doable but likely with some modeling (e.g., disconnected tables) and tricky DAX. Why not just create a visual that shows loans about to move into the next group (i.e., loans at 30, 60, 90 days)?

Pat

[Elmarius123]

How? Do i in anyway have to write a dax column that will show the previous periods bucket?  So i will get the bucket in period A and a bucket in perioud A-1. Then i can show the bucket changes.. i wanted a easy solution)