topic Re: Create the data table for sankey diagram in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4409848#M175121 <P>Thanks for this. Yes, it works. But what exactly I wanted is the below. I just did a drawing. Hope you can understand it.<BR /><BR /></P><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Customer</TD><TD>Before</TD><TD>Product</TD><TD>After</TD></TR><TR><TD>1</TD><TD>R</TD><TD>C</TD><TD>No</TD></TR><TR><TD>2</TD><TD>A</TD><TD>C</TD><TD>J</TD></TR><TR><TD>3</TD><TD>No</TD><TD>C</TD><TD>D</TD></TR><TR><TD>4</TD><TD>A</TD><TD>C</TD><TD>J</TD></TR><TR><TD>5</TD><TD>B</TD><TD>C</TD><TD>K</TD></TR><TR><TD>6</TD><TD>B</TD><TD>C</TD><TD>K</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><img /></P> Thu, 13 Feb 2025 21:41:10 GMT temptester 2025-02-13T21:41:10Z Create the data table for sankey diagram https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4407687#M175011 <P>I have a table like below and trying to create a sankey diagram using the free version.</P><P>&nbsp;</P><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Customer</TD><TD>Status</TD><TD>Date</TD><TD>applicatoin no</TD><TD>product</TD><TD>Before</TD><TD>After</TD></TR><TR><TD><FONT color="#993300">1</FONT></TD><TD><FONT color="#993300">in</FONT></TD><TD><FONT color="#993300">1/1/2024</FONT></TD><TD><FONT color="#993300">1</FONT></TD><TD><FONT color="#993300">C</FONT></TD><TD><FONT color="#993300">No</FONT></TD><TD><FONT color="#993300">D</FONT></TD></TR><TR><TD>1</TD><TD>in</TD><TD>1/2/2024</TD><TD>2</TD><TD>D</TD><TD>C</TD><TD>No</TD></TR><TR><TD>2</TD><TD>out</TD><TD>1/3/2024</TD><TD>3</TD><TD>J</TD><TD>No</TD><TD>C</TD></TR><TR><TD><FONT color="#993300">2</FONT></TD><TD><FONT color="#993300">out</FONT></TD><TD><FONT color="#993300">1/4/2024</FONT></TD><TD><FONT color="#993300">4</FONT></TD><TD><FONT color="#993300">C</FONT></TD><TD><FONT color="#993300">J</FONT></TD><TD><FONT color="#993300">M</FONT></TD></TR><TR><TD>2</TD><TD>out</TD><TD>1/5/2024</TD><TD>5</TD><TD>M</TD><TD>C</TD><TD>No</TD></TR><TR><TD><FONT color="#993300">3</FONT></TD><TD><FONT color="#993300">in</FONT></TD><TD><FONT color="#993300">1/6/2024</FONT></TD><TD><FONT color="#993300">6</FONT></TD><TD><FONT color="#993300">C</FONT></TD><TD><FONT color="#993300">No</FONT></TD><TD><FONT color="#993300">L</FONT></TD></TR><TR><TD>4</TD><TD>in</TD><TD>1/7/2024</TD><TD>7</TD><TD>L</TD><TD>No</TD><TD>C</TD></TR><TR><TD><FONT color="#993300">4</FONT></TD><TD><FONT color="#993300">in</FONT></TD><TD><FONT color="#993300">1/8/2024</FONT></TD><TD><FONT color="#993300">8</FONT></TD><TD><FONT color="#993300">C</FONT></TD><TD><FONT color="#993300">L</FONT></TD><TD><FONT color="#993300">No</FONT></TD></TR></TBODY></TABLE><P><BR />In the sankey, I want to show the before-&gt;product-&gt;after sequence for each customer where product = "C" (highlighted). So its like souce-<STRONG>Before</STRONG>, middle-<STRONG>C</STRONG>, destination-<STRONG>After</STRONG>. Can you please help me create the data table for this. Thanks.</P><P>&nbsp;</P> Thu, 13 Feb 2025 02:47:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4407687#M175011 temptester 2025-02-13T02:47:26Z Re: Create the data table for sankey diagram https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4408558#M175057 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="913499" data-lia-user-login="temptester" class="lia-mention lia-mention-user">temptester</a>&nbsp;,</P> <P>&nbsp;</P> <P>You need to put the product field into <STRONG>source labels</STRONG>, and then turn on <STRONG>date link labels</STRONG> in the data format.</P> <P><img /></P> <P>&nbsp;</P> <P><img /></P> <P><img /></P> <P>Best Regards,<BR />Adamk Kong</P> <P>&nbsp;</P> <P>If this post <EM><STRONG>helps</STRONG></EM>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.</P> Thu, 13 Feb 2025 07:53:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4408558#M175057 Anonymous 2025-02-13T07:53:04Z Re: Create the data table for sankey diagram https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4409848#M175121 <P>Thanks for this. Yes, it works. But what exactly I wanted is the below. I just did a drawing. Hope you can understand it.<BR /><BR /></P><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Customer</TD><TD>Before</TD><TD>Product</TD><TD>After</TD></TR><TR><TD>1</TD><TD>R</TD><TD>C</TD><TD>No</TD></TR><TR><TD>2</TD><TD>A</TD><TD>C</TD><TD>J</TD></TR><TR><TD>3</TD><TD>No</TD><TD>C</TD><TD>D</TD></TR><TR><TD>4</TD><TD>A</TD><TD>C</TD><TD>J</TD></TR><TR><TD>5</TD><TD>B</TD><TD>C</TD><TD>K</TD></TR><TR><TD>6</TD><TD>B</TD><TD>C</TD><TD>K</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><img /></P> Thu, 13 Feb 2025 21:41:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4409848#M175121 temptester 2025-02-13T21:41:10Z Re: Create the data table for sankey diagram https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4409850#M175122 <P>Thanks for this. It works. But below is what I exactly wanted. I hope you can understand the drawing.</P><TABLE border="1" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Customer</TD><TD>Before</TD><TD>Product</TD><TD>After</TD></TR><TR><TD>1</TD><TD>R</TD><TD>C</TD><TD>No</TD></TR><TR><TD>2</TD><TD>A</TD><TD>C</TD><TD>J</TD></TR><TR><TD>3</TD><TD>No</TD><TD>C</TD><TD>D</TD></TR><TR><TD>4</TD><TD>A</TD><TD>C</TD><TD>J</TD></TR><TR><TD>5</TD><TD>B</TD><TD>C</TD><TD>K</TD></TR><TR><TD>6</TD><TD>B</TD><TD>C</TD><TD>K</TD></TR></TBODY></TABLE><P><img /></P> Thu, 13 Feb 2025 21:46:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4409850#M175122 temptester 2025-02-13T21:46:16Z Re: Create the data table for sankey diagram https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4410762#M175161 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="913499" data-lia-user-login="temptester" class="lia-mention lia-mention-user">temptester</a>&nbsp;,</P> <P>&nbsp;</P> <P>According to the field information provided by Sankey visual, the best way to show this effect is to enable data link labels.</P> <P><img /></P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>Best Regards,<BR />Adamk Kong</P> <P>&nbsp;</P> <P>If this post <EM><STRONG>helps</STRONG></EM>, then please consider <EM><STRONG>Accept it as the solution</STRONG></EM> to help the other members find it more quickly.</P> <P>&nbsp;</P> Fri, 14 Feb 2025 09:18:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4410762#M175161 Anonymous 2025-02-14T09:18:54Z Re: Create the data table for sankey diagram https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4416533#M175376 <P>Sorry for the delayed response. I think the previous image wasn't clear. My actual dataset is too large and the names are long. So printing it in the middle is a bit cluttered. Can we make a similar Sankey?</P><DIV class="">&nbsp;</DIV><P><img /></P> Tue, 18 Feb 2025 21:52:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Create-the-data-table-for-sankey-diagram/m-p/4416533#M175376 temptester 2025-02-18T21:52:04Z