Forum Discussion
Google Form Visualization
Anonymous It might be nice to keep one table that has one row per respondent? See if this webinar on survey data gives you any inspiration: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS
I didn't get too complex in this one, but I do often do what you have done by creating a column for 'question' and column for 'response'. I just think you're missing the Dim and Fact table concept to be able to create exactly the chart you want. https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html
Community ChampionAnonymous It might be nice to keep one table that has one row per respondent? See if this webinar on survey data gives you any inspiration: https://www.excelwithallison.com/MCT/news#h.p_NkgcNxVFFYaS
I didn't get too complex in this one, but I do often do what you have done by creating a column for 'question' and column for 'response'. I just think you're missing the Dim and Fact table concept to be able to create exactly the chart you want. https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html
Hi! Thank you for the webinar link! It really helps in creating the charts I want, but I have a question regarding the fact tables. Since the tables are unpivoted for each question, will the new entries be in the format of the fact tables when I refresh the data? Because the PBIX is directly linked to the survey's Google Spreadsheet.
- AllisonKennedy
Anonymous You're very welcome, glad it helps! 🙂
Everything you do in Power Query is saved, so since the pbix is linked directly to the Google Spreadsheet, every time you refresh the data, Power BI will follow every step you created in Power Query. It starts by going to the Google Spreadsheet and grabbing all the rows, then transforms, unpivots, references, adds index column, etc. So the final result is yes, the new entries will be in the format of the fact tables when you refresh the data. Such a fun tool! Let me know if you have more questions around that.
Thank you so much for the explanation!! I've been reading a lot about Power Query so this really makes sense 🙂