Power BI Sankey Diagram - multi levels

[liorro]

hi,

i need help with creating a Sankey diagram multi level

as you can see below, i dont have the "A->B->D" flow:

Data:

First	Second	Third	Days
A	B		43
A	B	B	38
A	B	C	24
A	B	D	25
A	C		37
A	C	B	35
A	C	D	22
A	D		23
A	D	B	26
A	D	C	20

i tried this DAX

Table 2 =

UNION(

SUMMARIZE(

SELECTCOLUMNS('Table',"S",'Table'[First],"T",'Table'[Second]),

[S],

[T],

"Days", AVERAGE('Table'[Days])

),

SUMMARIZE(

SELECTCOLUMNS('Table',"S",'Table'[Second],"T",'Table'[Third]),

[S],

[T],

"Days", AVERAGE('Table'[Days])

)

)

[mahoneypat]

You may have to further transform your data.  Not sure that it will, but see if this article helps out.

Guest Post: Using List.Accumulate for Input/Output Genealogy – The BIccountant

Pat

[liorro]

thanks but it didnt helped me

[mahoneypat]

The ABD path is there but not as you expect.  There is a line from A to B, and also one from B to D.

Pat

[liorro]

can it appear as i want?