Sankey Diagram Issue

[theo_vent]

Hi all,

I am not getting anything when using a Sankey diagram with my dataset:

Date 1      -->        Date 2                  TOTAL

PNC                         PNE                         3

PNC                         PND                        2

PNC                         PNC                        2

PNE                         PNC                        1

PNE                         PND                        3

PNE                         PNE                         1

PND                         PNC                        3

PND                         PNE                         2

PND                         PND                        2

Sankey with Labels is the type of diagram I'm looking for but is not showing the "no movement" of a PNC in Date 1 who stays a PNC in Date 2.

Can anyone tell me what I'm doing wrong ?

Thanks in advance,

Theo

[v-sihou-msft]

@theo_vent

When using the Sankey or similar type of chart, you must have different source and target so that it can show the "movement". That's the reason why you can't get the anything on this visual.

Regards,

[gjohnson900]

No, I don't think that's right.  Power BI should be smart enough to know the difference between an element in the Source and an element in the Destination regardless of whether it has the same name.

I'm seeing intermittent issues where a third (or more) column is showing up on my report.  This would be desirable if there were more than just Source and Destination, but the "middle" column of nodes is wildly unintuitive for me and our users.  It really increases the cognitive load of people trying to understand what they're seeing.

I'd love to have a way of preventing this.