Forum Discussion
Split into rows
Hi All, I have a question on the split a column into rows. But when i perfor that action the total value would get affected. is there any possibilty to keep the total same and have the individua...
But ofcourse,
Load your file as usual, in the transform window select Split Column --> By delimiter
in this window click the dropdown arrow at Advanced options and under split into: select Rows
you might want to choose to remove the bottom total row and make use of the automatic total function when selecting a table in the power bi visualizations editor. Hope this helped!
Great answer!
