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
Dynamic prefilling for Microsoft Forms: • How to set fields in Microsoft Forms ...
Apply row-level security with your organizational hierarchy:
• Organizational Hierarchy-Based Dynami...
Schedule refresh on SharePoint file sources (which MS Forms is!):
• How to Schedule REFRESH on File & Fol...
🪽 CONNECT WITH ME
Blog: https://christine-payton.com/
LinkedIn: / christinehpayton
🎁 SUPPORT THIS CHANNEL
Shop: https://shop.bi-ome.com/
#survey #data #powerbi #forms
Watch video Get all your survey data in ONE visual! online without registration, duration hours minute second in high quality. This video was added by user Christine Payton 29 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,818 once and liked it 285 people.