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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

How remove the unwanted letters in a column.

Hello, 

How can I remove the unwanted letters in the category column below?
I want to remove the PV from each row. 
Thanks!

ROG_BI22_0-1649344391998.png

 

1 ACCEPTED SOLUTION
Whitewater100
Solution Sage
Solution Sage

Hi:

You can do this a couple of ways I know. Here is a calc column:

New Cat = REPLACE(Data1[Category],21,2,"")
Whitewater100_0-1649347488201.png

You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.

Hope this helps!

View solution in original post

4 REPLIES 4
Whitewater100
Solution Sage
Solution Sage

Here is Power Query fix:

Whitewater100_1-1649347695892.png

 

Whitewater100
Solution Sage
Solution Sage

Hi:

You can do this a couple of ways I know. Here is a calc column:

New Cat = REPLACE(Data1[Category],21,2,"")
Whitewater100_0-1649347488201.png

You can also do in Power Query with ADDCOLUNM > Column by examples and type in first two and computer will catch on and fix all of them.

Hope this helps!

Anonymous
Not applicable

HEY @Whitewater100  Thanks! It was really helpful. 

Great! Thank you..

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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