Is it possible to shift Sankey values to the left with padding?

[Anonymous]

I currently have a sankey that looks like this

My goal is to create some kinda measure or use some kind of tool that will allow me to shift certain levels to the right. I am trying to force the values on the sankey to their specified level according to this table. Is this possible in Power BI?

[lbendlin]

This is not really a Power BI issue.  You need to modify/transform your data to be more suitable for a Sankey, including better bucketing and Source/Target pairing. As you can see from your screenshot it's not really useful in its current state.

You can unlock item positions in the Sankey visual and move them around as needed.

[Anonymous]

Hi, thanks for the reply. I know it is not an issue with Power Bi, I was just wondering if there was a work around to what I am trying to accomplish. This is mainly so I can ensure that all future data inputs will be placed in the right place for sure. Is there no way to add padding to a sankey visual?

[lbendlin]

As I said, this is the least of your problems. You will want to work on rebuilding your source data into a format that is compatible with Sankey's concept of Source and Target.

[Anonymous]

The data right now currently displays the correct values, I am trying to have it shifted more for aesthetic reasons so it is easier for the user to see. For eample if I narrow down the graph to display something from level 1 it will show all flows related to that. Do you have any tips I can use to restructure the data so I can sort of force it to behave how I want it to?

[lbendlin]

Have at most ten sources and targets.

[Anonymous]

I saw that this problem is possible in R, do you know how I would go about doing that? I saw that alluvial is a package that is allowed in Power Bi.

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please review the following links and check whether they are what you want.

Creating Custom Sankey Diagrams Using R

anyone successfully generate sankey chart with R plotly in powerBI desktop and powerBI service?

No, this is a HTML plot, that cannot work. You have to use pbiviz, see here. 

i tried and it works with pbiviz. Sankey created by R plotly can be displayed in powerBI desktop and powerBI service 

Best Regards