Forum Discussion
Empty filter (not blank) to be excluded
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
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