Forum Discussion
Sankey chart
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
2 Replies
ppm1Solution Sage
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
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)
