Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello. Looking for a little help with this. I am collecting survey data that I would like to summerize in Power BI. Each respondands submissions are stored row by row.
I load the data in
but I am getting stuck on how to create a table with that data where the questions are on the Y axis and the Responses (all the same Likert scale options) are along the X axis with a count within the table.
I've not had enough experiene with the Transpose or Pivot features to make them work although I am not certain that is what needs to be used for this issue anyway. My end goal is to have the table with response counts that can be used for filtering. I would also have differnet slicers on the page that would filter this table as well. I cant get to that point until I figure out this. Any guidance would be apprecaited!
Solved! Go to Solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |