Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
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!!
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
129 | |
78 | |
76 | |
60 | |
53 |
User | Count |
---|---|
164 | |
86 | |
68 | |
68 | |
58 |