sankey chart visual

[Anonymous]

I have a the following data set:

Pers_NO    Type                 From Job Code        To Job Code

1             Promotion               DV01                       DV02

2             Promotion               DV03                       DV04

3             Promotion               DV01                       DV03

1             Promotion               DV02                       DV03

2             Promotion               DV04                       DV05

3             Promotion               DV03                       DV04

I am creating a sankey diagram with Source as From Job Code and Destination as To Job Code. However, I would like a diagram, that contains the source as DV01, and I would like to see the flow from this job code, something that looks like follows

So when i filter for dv01, it should show me a flow like this, suppose 100 people were in dv01 out of which 20 got promoted to dv02.Out  of those 20, 4 moved to dv04. I want to show such a visual in sankey, for different job codes.

However, if i filter now for dv01, it will show me the record only for row 1 and 3 as in the above table.

I would like to know if this can be done. Thank You!

[v-frfei-msft]

Hi @Anonymous,

Based on my test, it is not possible to meet your requirement currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

Regards,

Frank