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 have a column I need to split by colon, but each cell in the column has a varying number of items. In the Advanced section of "Split Column by Delimiter", there is the option to select the number of columns to split into, but if the number is to low, it doesnt split the column enough and if the number is too high, it splits into too many empty columns. How can I split the column dynmically, depending on the number of items in a call. Hope that makes sense.
Item |
1, 2, 3 |
4 |
5, 6, 7, 8 |
9, 10 |
So it would split like this...
Item_1 | Item_2 | Item_3 | Item_4 |
1 | 2 | 3 | |
4 | |||
5 | 6 | 7 | 8 |
9 | 10 |
Thanks in advance.
@StuartSmith , My advice would be split into rows and then use matrix visual to display it
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |