Blanks in Filters

[Anju_isa]

Hi All,

I have a star schema data model with may to one relationships. In the front visualisation i could see that the filters are having a blank value..but when i investigated for the blanks in tabular view there is no data associated with the blanks.

Also if i select the blank from slicer also there is no records or data associated with it.

Anyone can assist me to understand why the blanks are coming in slicer without any associated data.

Thanks in advance for the answer.

[rajendraongole1]

Hi @Anju_isa - Create custom filters or calculated columns to exclude null or blank values.In Power BI, use DAX expressions to filter out blank values. For example:

FilteredColumn = IF(ISBLANK([YourColumn]), "Not Applicable", [YourColumn])

or even you can try to create the new column to replace blank if any with No value.

CleanedColumn = IF(ISBLANK([DimensionKey]), "No Value", [DimensionKey])

use the new calculated column in slicer and check.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Anju_isa]

Hi,

Thanks for replying...but we cannot go with a calculated column which exclude blanks fully. Because we are handling the month, year wise data so in some month there can be chance of having value as blank which has data associated with it. What we want to know is that what is making the blank value in filter if there is no associated data. But if in any month there is an associated data for the blank we need to see the blank in the filter. By removing the blanks may cause loss of data.