Sankey - How to present Node with no end point

[qqqqqzhang]

I have a dataset that looks like below. On the first row, there are 100 records that stayed in A without moving. If I plot it in Sankey, it creates a node that represents the blank and draws a path from A to it. I'd really like to remove that path and the end node and just represent part of A as the end point. Is there a way to do it?

From	To	Total
A		100
A	B	200
B	C	300
B	D	240

[v-yuezhe-msft]

@qqqqqzhang,

When you filter out blanks for the To field as shown in the following screenshot, does it give your expected result?


Regards,
Lydia

[qqqqqzhang]

@v-yuezhe-msft Thanks for your reply but it does not really resolve the issue. When I filter out the blank, it filters out the whole 100 records. I still need them to show up on the starting point but I don't want them to show up on any path.

[v-yuezhe-msft]

@qqqqqzhang,

Could you please show expected result in screenshot?

Regards,
Lydia

[qqqqqzhang]

@v-yuezhe-msft Please see the image above. Basically, I'd like to show that additional 100 records on A, while there is no path going out from it. So it shows up as a longer extention of rectangle. Does it explain it?

Thank you for your help!
Qi

[v-yuezhe-msft · Accepted solution]

@qqqqqzhang,

You can work around the issue by creating the following columns in your table.

NewFrom = IF(Table14[To]="","A1",Table14[From])
NewTo = IF(Table14[To]="","B",Table14[To])



Regards,
Lydia

[qqqqqzhang]

@v-yuezhe-msft Please see the image above. Basically, I'd like to show that additional 100 records on A, while there is no path going out from it. So it shows up as a longer extention of rectangle. Does it explain it?

Thank you for your help!
Qi