Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anju_isa
New Member

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 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.

Anju_isa_0-1716955079011.png

 

 

Thanks in advance for the answer.



2 REPLIES 2
rajendraongole1
Super User
Super User

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!!

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.