Get all your survey data in ONE visual!

This technique unpivots Microsoft Forms data in Power Query to combine responses into a single column in Power BI. This lets us calculate percent of total and counts of responses by question without having to create a measure and visual for every question.

We connect to the Microsoft Forms data in SharePoint in this example, which we can schedule refresh on, but it will work survey data from other sources as well.

⏲️ TIMESTAMPS
0:00 Intro/demo
1:48 Connect to the data
4:16 Shape and clean the data
7:38 Create the measures
9:50 Configure the visual
12:50 Create a score “out of” a number
14:30 Other ideas

▶️ RELATED VIDEOS
- Apply row-level security with your organizational hierarchy:
Schedule refresh on SharePoint file sources (which MS Forms is!):

🪽 CONNECT WITH ME

🎁 SUPPORT THIS CHANNEL

#survey #data #powerbi #forms

[VaneyRio]

Thanks! I was serious about the coffee. May your day be filled with pretty moments.

[maheshgupte]

One more awesome tutorial. Thank you for teaching us.

[mrneveradullmoment]

THANK YOU for the full walk through. I can't tell you how hard this is to find...

[MadisonLiddell]

This was outrageously helpful, thank you!

[Nalaka-Wanniarachchi]

Nice one.
Bit of a few codes with ALLEXCEPT,

% of Total =
var countResponse = COUNTROWS('Responses')
var allResponsesForQuestion = CALCULATE(COUNTROWS('Responses'), ALLEXCEPT(Responses, Responses[Question]))
RETURN DIVIDE(countResponse, allResponsesForQuestion)

[KimAlbertDeMesa]

Hi, is there a way that I can use a slicer so my visuals will show the response for each question one at a time?

[janrylingaya]

How about with filtering and slicing for a specific responses such as responses from specific city? Is there any way to go around with it? Thank you in advance for the possible favorable response.

[wwpharmacist]

Thank you
What if I have multiple selection in the columns separated by semicolon, is Split in to rows will help, I analyzing stack overflow data set survey for 2023 and trying to solve these Columns but the data size increases dramatically, any suggestions
Thanks

[lol-vqdh]

how does this work with multiple choice questions devided by commas?

[flopense]

Really helpful ! Thanks ! Now... how can we apply this when instead of multiple choices microsoft form only, you have a survey with a list of rows (A, B, C...) with a satisfaction rate in column (very satisfied to very unsatisfied) ?

[Denis-iqkj]

Amazing guide, thank you! Let's say I send out a monthly anonymous team survey with 10 questions similar to your example. How can I compare responses from previous surveys with the same questions, so that if we look a year back we can see the difference in responses month by month?

[Autocurator]

Hi
Please help me with a video on how to visualise nps for multiple branches/departments in power bi.

[JasonYates-sw]

This was a great Video. Thanks for uploading it. I am still new to Power BI but wanted to know if it was possible to set this up a template or model for future surveys? I'd like to spend time positioning graphs and charts, but can it be re used for a new survey. It would be the same exact one, but new answers from say a different department. Or will the fact that we need to create a new non table version of the data cause issues? Thank you.

[mariakosberg]

Hi, this was fantastic and exactly what I was after. I was wondering is the '% of Total' measure. It is possible to reference to multiple columns than just questions. For e.g. to find the % of total by the country, age and gender a respondent is from? Thank you :)

[michelebuzzi]

I know this comment is completely out of context, but have you by any chance experienced issues with the new February version related to the message 'Cube Table must have exactly one island'?

[maheshgupte]

Dear Cristine,
I hope you are doing well,
need one help in one of my power App Project. where I want to provide a user to
1- Download a Excel template
2 Fill the template
3 User should be able upload the template using power App.
4 and patch the records to database MS lists
I found 2 Tutorial on YouTube but it confusing to me please check if you can help me with this requirement it will be great help.

Tutorial Link :

[vivekkoli]

Thank you so much, this is something that I was really looking for. Cheers !!