Forum Discussion

corbusier's avatar
corbusier
Advocate IV
9 years ago
Solved

Modeling data for Funnel Chart

Hi all, I am looking for a way to display a Conversion Funnel for our app. We have 7 different stages, and one user would have to go through the different stages in order to get to the end (sorry if ...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi corbusier,

    I test it using your sample table.

     

    Please replace the table header using 1,2 and 3. Right click the table->Power Query, select the 1,2 ,3 columns and click the unpivot columns(highlighted in red line).



    Click the apply&close on home page, you will get expected result.

    Best Regards,

    Angelia

LaurentCouartou's avatar
LaurentCouartou
Solution Supplier
9 years ago

You could add all your timestamps columns  (with a Count aggregation) to the Values role of your funnel chart, or even write a measure for every column. Did you try that?

 

Regarding the "missing steps", I would just go for a simple rule like "if we have a timestamp for step x, then we should have a timestamp for all previous steps", that I would enforce at the query level.