How to skip blank cells?

[PiotrBZMZ]

I've got a column with Owners of many type of products. Some of them are empty because i'm making a warehouse inventory and i want to show spaces that are still free, but it's not the main topic. Is there a way to create a new column maybe, or a new measure that will just show me those Owners without that empty spaces? 

[amitchandak]

@PiotrBZMZ , Create a new column in power query using Text.Trim

Text.Trim([Column])

or

Text.Replace([Column], " ", "")

In Dax you can use substitute

substitute([Column], " ", "")

[PiotrBZMZ]

@amitchandak 

Now it shows me something like this, (Blank) option, can we do something to not show it at all?

[amitchandak · Accepted solution]

@PiotrBZMZ , In visual level filter add this column and put is not blank as the filter (advance filtering)