Forum Discussion

alexsimpson's avatar
alexsimpson
Helper I
6 years ago
Solved

How to show a process flow

Hi,

 

I have data as follows

 

Client IDStep BeforeStep AfterDate Changed
11.0 Call Client2.0 New Business01/01/2020
21.0 Call Client2.1 Client Not Proceeding01/02/2020
12.0 New Business3.0 Client Not Proceeding01/03/2020

 

I want to be able to show the flow through the process i.e. how many have gone from call client to new business etc. 

 

I was thinking of using a decomposition tree and then using groups as per this post.... https://community.powerbi.com/t5/Desktop/Decomposition-Tree-with-Groups/m-p/886980

 

But I cant get it to work. Can anyone recommend a way I can see the flow? The output ideally would look like Google Analytics Behaviour chart.

 

Many thanks in advance,

 

Alex

 

 

2 Replies