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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
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

corbusier's avatar
corbusier
Advocate IV
9 years ago

Thank you, v-huizhn-msft, I hadn't seen that option!