Forum Discussion
Empty filter (not blank) to be excluded
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
Hi Anonymous,
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
1 Reply
Hi Anonymous,
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