Split into rows

Question

Hi All,&nbsp;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 individual GPN for filters.&nbsp;Before Delimiting to rows&nbsp;&nbsp;After Delimiting to rows&nbsp;GPNValue&nbsp;GPNValueXE01,XE02,XE03100&nbsp;XE01100XE04,XE05200&nbsp;XE02100Total300&nbsp;XE03100&nbsp;&nbsp;&nbsp;XE04200&nbsp;&nbsp;&nbsp;XE05200&nbsp;&nbsp;&nbsp;Total700

anonymous · Answer

But ofcourse,Load your file as usual, in the transform window select Split Column&nbsp;--&gt; By delimiterin this window click the dropdown arrow at Advanced options&nbsp;and under&nbsp;split into:&nbsp;select Rows&nbsp;you might want to choose to remove the bottom&nbsp;total row and make use of the&nbsp;automatic total function when selecting a table in the power bi visualizations editor. Hope this helped!&nbsp;

anonymous · Answer

Anonymous&nbsp; a quick tip; when you select&nbsp;Advanced options in the split columns by delimiter window, you can select split by rows. This saves a step for pivotting your table!

amitchandak · Answer

&nbsp;Edit Query Mode (Latest version Transform Data in Home Tab)-&gt; Use Split Column option -&gt; Delimiter&nbsp;Referhttps://www.newtechdojo.com/unpivot-columns-in-power-bi/Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739 https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

anonymous · Answer

RanjanThammaiah&nbsp;Please follow below stepsGo to edit query and split the columns by , delimiterthen select the value column and select unpivot other columns option.&nbsp;If it helps acept as solution.

ranjanthammaiah · Answer

Not sure if i am clear on my request.&nbsp;When i do the delimiter the values are repeting with ech other and i am getting the dashboard number affected.&nbsp;Regards,Ranjan

Forum Discussion

Split into rows

7 Replies

Related content

Split and transform columns into rows

split rows

Split values in one row into multiple

Splitting Column values

Split array into rows

Before Delimiting to rows		After Delimiting to rows
GPN	Value	GPN	Value
XE01,XE02,XE03	100	XE01	100
XE04,XE05	200	XE02	100
Total	300	XE03	100
		XE04	200
		XE05	200
		Total	700