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
- Dynamic prefilling for Microsoft Forms: https://youtu.be/0NJwsdyWcqo
- Apply row-level security with your organizational hierarchy:
https://youtu.be/Z0eeTTL7EhQ
Schedule refresh on SharePoint file sources (which MS Forms is!):
https://youtu.be/ba1Akv63GDQ
🪽 CONNECT WITH ME
- Blog: https://christine-payton.com/
- LinkedIn: https://www.linkedin.com/in/christinehpayton/
🎁 SUPPORT THIS CHANNEL
- Shop: https://shop.bi-ome.com/
#survey #data #powerbi #forms