Forum Discussion
Funnels in Power BI
Hi All,
Im not sure how to display that kind of information in power bi and if powerbi have relevent charts to that kind of information.
I have a data of users and 5 actions they can do in any order they want with the datetime they actually did that
it looks like
User | ActionA | ActionB | ActionC | Action D
111 26/8/18 25/8/18 22/8/18 21/8/18
112 21/8/18 22/8/18 24/8/18 23/8/18
...
I want to see how the users acts, so I want to know how many went from A>B>C>D and how many A>C>B>D and so on..
More then than, I want to know how many drop in the middle of the proccess, I mean like A>B>DONE(didnt do actions C and D)
or B>C>DONE
In my first topic
https://community.powerbi.com/t5/Desktop/Funnels-in-Power-BI/m-p/501973#M234298
@ v-yulgu-msft already helped me with my first issue and I can know how many clients do each order, but not with the second issu
anyone have good advice?
or some other idea how i can display these usfull informaiton?
Thanks
1 Reply
- v-cherch-msftMicrosoft Employee
Hi Drors
It seems you may use COUNTROWS Function to get the count of blank date. For example:
Measure = CALCULATE ( COUNTROWS ( Dataset1 ), FILTER ( Dataset1, Dataset1[Date] = BLANK () ) )Regards,
Cherie