Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good day!
I'm trying to work with a JSON file within PowerBI. For most of the entries I can do "expand to new rows" but I've also a few columns with data and the List value in the same column and I'm not able to expand the data. How can I solve this?
Solved! Go to Solution.
Hi @Sander_NL
You can do a if statement to change the type to list, but if you have many columns with list like the screenshot, you might need to consider other ways instead of expanding each column...
if Value.Is([yourColumn], type list) = true then [yourColumn] else {[yourColumn]}
Thanks Vera this solves the problem!
Hi @Sander_NL
You can do a if statement to change the type to list, but if you have many columns with list like the screenshot, you might need to consider other ways instead of expanding each column...
if Value.Is([yourColumn], type list) = true then [yourColumn] else {[yourColumn]}
User | Count |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |