Preparing a data model for Sankey Charts in Power BI

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...

[@mikebeccaria]

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.

[@rinmai9225]

Tks Marco. So usefull

[@AgulloBernat]

mindblowing! I need to try it myself to comprehend it completely

[@davidirias3459]

SQLBI never fails !!! thank you Marco

[@justinogarcia3705]

Thanks

[@Nalaka-Wanniarachchi]

The Ultimate..

[@AtulayaShrivastava]

Great Visualization, Where can I get this data set??

[@SQLBI]

Download the sample file from the related article, the link is in the description!

[@Quynh_Phan]

How can you fix the color formatting even changing/adding layers with containing many attributes inside?

[@MarceloNieto-cl4tp]

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.

[@SQLBI]

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.

[@MT-oy2uk]

The Gods of Dax :)

[@nairobi203]

I have a headache now....