Forum Discussion
How to skip blank cells?
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?
PiotrBZMZ , In visual level filter add this column and put is not blank as the filter (advance filtering)
3 Replies
- amitchandak
Super User
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], " ", "")
Now it shows me something like this, (Blank) option, can we do something to not show it at all?
- amitchandak
PiotrBZMZ , In visual level filter add this column and put is not blank as the filter (advance filtering)
