Funnels in Power BI

[Drors]

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

[v-cherch-msft]

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