Forum Discussion
Multi level sankey chart over time
Thanks for the links, I had looked at the second one but the first one made me wonder why they used Y and N in the first pillar and Yes and No in the second. Which led me to think I needed to put number infront of my values. So all the values in MAJR1 have a 1 in front and MAJR2 have a 2 infront and so on. I think the pillar methodology doesn't work when you have the same values in Source and Target. I get the following now which is correct but I would like to have the header display without the numbers in front.
Hi hyattt ,
In order to provide you a suitable solution, could you please share some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? By the way, are the numbers (1, 2, 3, 4, 5) in front of MAJR1 and MAJR2 in the data itself, or are they added later? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards