Slicer filtered "IS no blank" show blanks

[Analitika]

I filtered slicer "IS no blank" but Blank still exist,

when remove filter apears two blanks

how to prevent this?

[dax · Accepted solution]

Hi @Analitika , 

Yes, as mentioned above, this might be cuased by " " or ""(when it show null in table, which could filter by "is no blank"). You could try to use isblank() to see whether this is blank. You could try below M code in your sample, then use filter like below

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WUtJRMlSK1YlWUgCyjMCs4uJiINsYzE5MBDJNlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [test = _t, id = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,each [test],each if Text.Trim([test])="" then null else [test], Replacer.ReplaceValue,{"test"})
in
    #"Replaced Value"

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Analitika , check do you data have blank space too " "

check len of data

new column = len([column])