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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
fgnavarrete
Helper II
Helper II

Special character that is not White in Column

Dear, I have a problem and it is shown in the image:

My RUT column has the function of being my primary key and has characters that, Power BI does not make me treat it as a white or null to be able to delete. I've tried to replace, clean, trim, try also with LEN and Unicode as to know what type of character it possesses but I didn't succeed.

Please help, as I do not know how to delete all records that meet this condition. Thank you.

fgnavarrete_0-1598673681109.png

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@fgnavarrete - When you say LEN and UNICODE below are using the DAX UNICODE and LEN functions? What does Power Query show when filtering? It is strange that it is zero-length, not blank, and the UNICODE value does not exist. Have you tried:

New Table = FILTER('Table',[RUT]<>"")

O

New Table = FILTER('Table',ISBLANK([RUT]) || LEN([RUT])>0)



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@fgnavarrete - When you say LEN and UNICODE below are using the DAX UNICODE and LEN functions? What does Power Query show when filtering? It is strange that it is zero-length, not blank, and the UNICODE value does not exist. Have you tried:

New Table = FILTER('Table',[RUT]<>"")

O

New Table = FILTER('Table',ISBLANK([RUT]) || LEN([RUT])>0)



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler I did the filter and it worked, I effectively remove the special characters and now the column has all its correct values, there are no longer special characters.

I turned around solving the subject and it didn't occur to me to make a filter that excludes the values from dysint to ""

Thanks a lot.

fgnavarrete_0-1598713790464.png

@fgnavarrete - Awesome, glad you got that solved. Weird one though!



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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