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.
I've got a table like so:
and I would like to convert the "labels" column from the list that exists to three new columns. Like the following:
closed_at | closed_by | dept | detection | priority | milestone | assignees |
null | null | Platforms | Passive notification | High | null | List |
null | null | Networks | null | Medium | null | List |
Not all labels will exist in the cell, so I need to be able to skip and insert null if that doesn't exist. And i would like to remove the text before and including the "::" in the rows. I've been using PowerBI for maybe 12 hours so apologies if this is simple to do. Please let me know if any more information is useful
Solved! Go to Solution.
Thanks, I think I was trying to do too many things in one operation. I ended up expanding the data, separating by semicolons, then splitting it out into columns in a separate step
@Anonymous , on the label column, at the end there is expand sign those two angled arrow in in opposite direction, click on that and check what options you have. It should allow adding columns or rows.
For steps refer this video around json. but steps should be same
How to import JSON Data: https://youtu.be/MPYfEetvFH4
Thanks, I think I was trying to do too many things in one operation. I ended up expanding the data, separating by semicolons, then splitting it out into columns in a separate step
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |