Forum Discussion
Splitting data in PowerBI
Hello BrandonP2121
In this case you should split the column into rows rather than columns. Luckily that option is built into the interface 🙂
In the Power Query editor, select the column, then go to Transform => Split Column => Split Column by Delimiter.
Then make selections as below, with Split into Rows selected under Advanced options:
Does that work in your situation?
Regards,
Owen
Yes that is what I was looking for, thank you!
I do have another question though, is there a way to link this query or use an equation to my data, so that whenever A,B shows up in like a graph for instance it would break A,B apart into A and B so that my graph would have a cummulative total of all As and Bs instead of combinations of it? Please let me know if this doesn't make sense, I'm new to Power BI and trying to convey what I am trying to do.
HI BrandonP2121,
Maybe you can try to enable 'unpivot column' on these columns. It will convert your fields to attribute and value then you can simply calculate with each item:
Regards,
Xiaoxin Sheng