help - Is it possible to filter sankey chart by other information except source, target and value?

[Anonymous]

hi team, 

i have upload a a csv  table called 'test.csv' with  containing below column header:

dataCenter, customer, companyID, MID, PID, step1, step2, step3, step4, step5, step6, step7, step8, step9

and next i create a new table in Modeling tab to transform the  format to source, target and value  by following DAX script:

sankey = UNION(

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[CMID],"Target",test[step1]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step1],"Target",test[step2]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step2],"Target",test[step3]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step3],"Target",test[step4]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step4],"Target",test[step5]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step5],"Target",test[step6]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step6],"Target",test[step7]),[Source],[Target],"Weight", COUNTROWS(test)),

SUMMARIZE(SELECTCOLUMNS(test,"Source",test[step7],"Target",test[step8]),[Source],[Target],"Weight", COUNTROWS(test)))

You see in the new table 'sankey' there's no SFDC, CMN, and CMID information, and looks like i can filter the sankey chart only by source, target and value columns. please refer to below screenshot.

But product manager and dev manager want to filter the sankey chart by dataCenter, customer and companyID.

Is it possible, and what should I do?

[lbendlin]

Usually you prepare your Sankey data in Power Query, or further upstream , with From/To columns.  Doing it in DAX is impressive, but rather cumbersome.

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

[Anonymous · Accepted solution]

@ibendlin  Thank you for the response. I finally find a solution for my post. no worry.😀

[Anonymous]

Hi @Anonymous , can you please share the solution. I have a similar need. Thanks!

[v-janeyg-msft]

Hello @Anonymous 

Is your problem been solved? If yes, kindly mark the helpful answer as a solution if you feel that makes sense.

Welcome to share your own solution. More people will benefit from the thread.

Best Regards

Janey Guo