Sankey Diagram - two pillars only

[giogiogio]

Hi all,

I am tracking geographical movements in two years and I am looking for a BI visual to do so effectively.
I am trying to set-up the Sankey diagram this way: Geo regions @ Year on source, Geo regions @ Year+1 on destination and count of ID as weight. The rusult i get is:

This is correct, but I want to have all source "buckets" on the left side (as geo region at Year 1) and all destination buckets on the right side (as geo region at Year 2).

How can I do this? If not possible, is there a different visual to be used to achieve this?

[amitchandak]

@giogiogio , you may have to create two dimesnions and make sure that one is filtered on year 1 and second one year 2

[giogiogio]

@amitchandak  I modeled the data table this way:

ID

Year

Geo @Year

Geo @ Year-1

Geo Flag

A slicer with single selection on Year let you choose the year of interest, Geo@Year is the destination and Geo@Year-1 is the source for the sankey. Geo Flag (Geo Change or Same Geo) is on another slicer.

What do you mean by create two dimensions ?