Forum Discussion
Modeling data for Funnel Chart
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
I was able to use the UNPIVOT function in SQL Server to get my data in the form that I needed it. I actually Googled "Funnel Chart Tableau" and the first blog had an example of how the data should look.
http://www.evolytics.com/blog/tableau-201-how-to-make-funnel-charts/
The data should look like this:
| Gender | Step | Players |
| Female | 1 | 371,393 |
| Female | 2 | 35,490 |
| Female | 3 | 36 |
| Male | 1 | 412,351 |
| Male | 2 | 36,741 |
| Male | 3 | 77 |
Whereas my data looked like this:
| Gender | Step 1 Players | Step 2 Players | Step 3 Players |
| Female | 371,393 | 35,490 | 36 |
| Male | 412,351 | 36,741 | 77 |
UNPIVOT worked.
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
Thank you, v-huizhn-msft, I hadn't seen that option!