Help Needed: Creating Sankey Diagram in making relationship in order to make filters to work

[anandprakashnm]

I am trying to map customer journey using Sankey Chart. I was able to create Sankey chart as shown in the Sankey chart youtube video by power Bi. 

Now the problem is that is that there is no relationship between my base table and newly created table. Due to that i am not abl to use filters for Sanky Diagram.

I have created new table using follwing query:-

sanky Table = UNION(SUMMARIZE('Table 1','Table 1'[Parameter 1],'Table 1'[Parameter 2],"Count",COUNTA('Table 1'[Parameter 1])),SUMMARIZE('Table 1','Table 1'[Parameter 2],''Table 1'[Parameter 3],"Count",'Table 1'[identifier]))

This is same query as exmplained in the youtube video.

I have a date and customer category as column in Table 1 and want to use that as filter. Can anyone help me with this.

[Anonymous]

@anandprakashnm , have this issue resolved? can you help share the solution as I am running into the same issue like you, i am not able to filter by other information in base table except source, target and value.

Thanks,

Cherie

[Anonymous]

@anandprakashnm,

Which youtube video do you refer to ? Based on your DAX, your table1 contains these columns( parameter 1 , parameter 2, parameter 3) except date column and category column, is there any possibility that you create relationship between Table 1 and newly created table using one of these columns?

In addition, we will appreciate that if you  can share sample data of Table 1 and post expected result here.

Regards,
Lydia