Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am building a report for a department who is wanting to pull data from Microsoft Forms. The data is from surveys on satisfaction. Because of the way that Forms data has each question as a column, plus each of the surveys in this case, have comment open text afterwards, I had to pivot the tables to place all questions and comments in one column. This has helped for filtering to drill down in the data. I have everything organized but need a way to have the questions and then the subsequent comment show side by side in a matrix along with other data for that specific question. The questions along with comment question are in a "Question" column and the answers are in a seperate column.
Prior to pivoting the table, I renamed all of the comment questions to a name tied to the original question since all of the comment questions said the same thing.
Question | Answer |
The service was great? | Strongly Agree |
Service Comment | Jane Doe was great at helping us |
The product I received was great? | Somewhat Agree |
In the example above I need the service comment (from answer column) to be next to the Service Question in a matrix visual.
@dbrandone I'm not sure about Pivoting the data here - generally we want it Unpivoted, but agree Microsoft Forms doesn't put data in the ideal Power BI format:
https://www.youtube.com/watch?v=UAjAtbN1MAY&feature=youtu.be
You may need to add in one additional table that includes the Question and the Group, ie:
Question | Group | Type |
The service was great? | Service | Likert |
Service Comment | Service | Free Text |
The product I received was great? | Product | Likert |
Product Comment | Product | Free Text |
Then you can use that information to pivot and put the comment next to the question.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |