Report: grouped by rows & columns (is this possible?)

Greetings everyone - report builders especially, I have a batch of survey responses (Answer Text) and I'd like to view them grouped by users (rows) & questions (column headings). Is this possible to...

Charting

excel

Riny_van_Eekelen

Platinum Contributor

Jun 01, 2021

stevep17 "Is this possible to achieve in Excel?" The answer is Yes!

How exactly is a bit difficult to explain in words, without some real data to play with. From looking at the pictures, I would first connect to and transform the data a bit with Power Query, then load the data into the Data Model. Then you need som DAX code that allows the text based answers to be entered in the value field of a pivot table.

Now, this may sound all very alien, if you have never seen or heard of this before. And if you are on a Mac, you can forget it altogether. So, if you can provide a file with some real, but anonymous data, I or someone else can get you started.