Split into rows

[RanjanThammaiah]

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 individual GPN for filters.

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

[amitchandak]

 Edit Query Mode (Latest version Transform Data in Home Tab)-> Use Split Column option -> Delimiter

Refer

https://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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[RanjanThammaiah]

Not sure if i am clear on my request.

When i do the delimiter the values are repeting with ech other and i am getting the dashboard number affected.

Regards,

Ranjan

[Anonymous]

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!

[oscar_bolanos]

Great answer!

[Anonymous]

@RanjanThammaiah Please follow below steps
Go to edit query and split the columns by , delimiter
then select the value column and select unpivot other columns option. 
If it helps acept as solution.

[RanjanThammaiah]

Not sure if i am clear on my request.

When i do the delimiter the values are repeting with ech other and i am getting the dashboard number affected.

Regards,

Ranjan

[Anonymous]

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