Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |