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.
Hi,
I have some Sharepoint surveys and I have to analize the data using PowerBI.
Problem is, every answer is a List with Records inside.
I tried using the button next to each column name, but that just made the table expand exponentialy.
I don't know how to do this. Every other post about this only works with a single column, I have 10.
Hi @Idigorasu m
I am not clear about your data, if you want to expand the data, I think you could click button like below
If this is not waht you want, please correct me and explain it to me in details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Zoe, thank you for your help.
When I try to extract the values, it gives me an error.
Expression.Error: Unable to convert a value of type Record to type Text.
Details:
Value=
Answer=10
Question=Teacher 1
Type=[Type]
I guess it's because each Record has 2 values inside. A text and a number.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |