Preparing a data model for Sankey Charts in Power BI
HTML-код
- Опубликовано: 4 дек 2023
- How to correctly shape a data model and prepare data to use a Sankey Chart as a funnel, considering events related to a customer (contact, trial, subscription, renewal, and others).
Article and download: sql.bi/819239?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin... - Наука
This is one of those videos that I will definitely need to watch a couple times. I LOVE the high level of content here that continues to challenge me and think more deeply about functional programming strategies.
Tks Marco. So usefull
SQLBI never fails !!! thank you Marco
mindblowing! I need to try it myself to comprehend it completely
Thanks
Great Visualization, Where can I get this data set??
Download the sample file from the related article, the link is in the description!
The Ultimate..
How can you fix the color formatting even changing/adding layers with containing many attributes inside?
Is there a reason why my Events table would create rows for approx each iteration of eventID? For example, my data has 15 distinct batches (not counting 99) where a person can land. 1-5 are the first level (your web and phone contact), 6-10 is the second level, 11-12 the third level, and 12-15 the last level of the sankey that I want. The first unique ID in my data produces rows for 1-11, 15, and two blank rows for some reason even though they should only have rows for 2, 9, and 12.
Try to reproduce the issue using the sample file in the article and write a comment in the article comments, if you can repro using the sample file we can help there.
The Gods of Dax :)
I have a headache now....