Empty filter (not blank) to be excluded

[gianlu2]

Hello everyone,

I am not a PowerBI's expert and I am having the following issue. I have a list of records and I wants to compare the total number of records and the records that have a labels.   I would like to exclude the red value from the total sum. If I deselect it it is applied to everything. I would like to count exlude this category and the (Blank), how can I do it?

Thank you in advance

[Anonymous · Accepted solution]

Hi @gianlu2,

It seem like your table has some records that existed 'whitespace' characters.
If you want to exclude them, you can setting a filter on this fields to filter 'whitespace' characters(advanced filter mode and exclude filter) or try to do replace value operation in query editor side to replace/remove these character and they will be merged with the "blank" options in the filter.

Replace values and errors - Power Query | Microsoft Learn

Types of filters in Power BI reports - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng