Forum Discussion

Anju_isa's avatar
Anju_isa
New Member
2 years ago

Blanks in Filters

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 ...
General Comment
Need Help
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

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's avatar
Anju_isa
New Member
2 years ago

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.