Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Antoinette123
Helper I
Helper I

Separating columns in Power Query

Hi! There is a pivot table. How to separate the column "Plan-Fact" (that has options -kinda filters 'Plan', 'Fact' inside of it) into 2 separate columns named "Plan" and "Fact"?

1000035577.jpg

13 REPLIES 13
Anonymous
Not applicable

Hi @Antoinette123 ,

 

Is your problem solved? If not, can you provide me with some of what it looks like in your Power Query?

It would be nice to have a more detailed description of the problem, thank you.

When you provide screenshots, please protect your privacy.

 

Best Regards,

Stephen Tao

 

ahadkarimi
Solution Specialist
Solution Specialist

Hey @Antoinette123, try and let me know if there is any problem.

Load Data into Power Query.
Select "Plan-Fact" Column.
Transform → Split Column → By Delimiter (choose appropriate delimiter).
Rename Columns to "Plan" and "Fact".
Close & Load.

I've tried that, it doesn't do what I need, unfortunately. Cause the whole Plan/Fact column has only 2 possible values: either "Plan" or "Fact", not 2 values to separate them by  delimiters

@Antoinette123 try this way and let me know if there is any issue:

Select "Plan-Fact" and any key columns.
Go to Transform → Pivot Column.
Pivot "Plan-Fact", choose your values column, set to "Don’t Aggregate".
Hit Close & Load.

No, also not that. I got something strange 🙂

@Antoinette123 Could you explain it in more detail, or provide a better example, or if possible, provide and share a part of the sample file so that I can help better?

Where can I send you the file/mail?

you can use one drive or send it to ahad.karimi8@gmail.com

Thank you! I sent the file. In the file the "plan-fact" column is kinda a filter: you'll get a column or both columns depending on what you choose.Instead, I need 2 separate columns, so I can do some calculations, like fact devideved by plan etc.

@Antoinette123, do you load this Excel file in Power BI?
I see that it creates 2 different columns for plan and fact.

ahadkarimi_1-1723611018338.png

 

 

No, it was an ordinary table, then I used power query to create a pivot table. I was told to create a table similar to what I did, but with 2 separate columns.

I selected "Plan-Fact" and Month columns. Went to Transform → Pivot Column. Pivot "Plan-Fact", set to "Don’t Aggregate". And in the final table there was only 1 column, not 2 separate "plan" and "fact" columns

@Antoinette123c, can you send another photo like the one below and explain a bit more clearly?

ahadkarimi_0-1723609228411.jpeg

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.