Forum Discussion
Sankey diagram
Hi,
I'm new on Power BI and i need help with shaping my sankey diagram. I have pivoted data which have 19 columns which i need to show a flow for. I dont need all 19 columns however i need to show which areas handled (assisted) with that reference. Like a call flow from one department to the other up until the end. Or is there another diagram i can use?
Reference | Date | Queue_1 | Queue_2 | Queue_3 | Queue_4 | Queue_5 | Queue_6 | Queue_7 | Queue_8 | Queue_9 | Queue_10 |
sccr3cmxvsl04 -1 | 2019-03-18 | businessbanking | onlinebanking | businessbanking | onlinebanking |
|
|
|
|
|
|
sccr1cmxvsl04 -2 | 2019-03-18 | forex | onlinebanking | card | easy | onlinebanking |
|
|
|
|
|
sccr3cmxvsl04 -3 | 2019-03-28 | premier suite | onlinebanking |
|
|
|
|
|
|
|
|
sccr1cmxvsl04 -4 | 2019-03-28 | gold | telephonebanking | onlinebanking |
|
|
|
|
|
|
|
2 Replies
v-yuta-msftCommunity Support
tshepino ,
I dont need all 19 columns however i need to show which areas handled (assisted) with that reference. Like a call flow from one department to the other up until the end.
Could you please clarify more details about requirement above and show the expected result?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Hi
The desired outcome is for me to show how one reference move from Queue_1 to Queue_6
So starting point will b for example, onlinebanking -> credit card-> Bankingapp -> personal loans -> home loans then ends
I need to show this flow using a diagram and Sankey looks like a perfect app
