Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
As the title says, I have an answer column where there are very few instances of Lists and Records in my questionnaire data. I've fully expanded all columns already and this was the final outcome.
I was wondering if it was possible to expand this, I believe the data can be obtained from the list pretty easily (I just don't know how to) as this is specific answer is from a multiple choice question and upon clicking on it, I get the answer.
Dealing with the record may be a little tricky as this is tabular data (a table with year date as column headers, and a specific occurence as rows, where the user enters numbers correpsonding to a total amount for that year on each row.) When I expand the record, the below is what I get back.
Any support would be appreciated, if more information is required please do let me know. Thanks in advance 🙂
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 9 | |
| 6 | |
| 5 | |
| 3 |