Blank value appears on Slicer visual for Dimension when i connect to Fact table

[sd782]

Hi All,

I see a blank value appear on the slicer from a dimension column (i manually created the Dimension table) only when i connect it to the fact table in the data model.
This is causing an issue in my measure on the Fact table. Is there a reason for the Blank to appear on my slicer ?

How can i avoid it ?

Thank you.

[Bordalos · Accepted solution]

@sd782 it might be because you have values in your fact table thar are not in the slicer. 

See the following example.

• Fact table has 10 procucts A-K (excluding I by purpose)  
• Slicer 1  has 8 Prod: A-H
• Slicer 2 has 11 Prod: A-K ( including I ) 

 

As J and K are not  on Slicer 1 it is automatically showing a blank. It doesnt happen for Slicer 2 as it includes all the Prod. in fact table.

In this situation you need to be careful if you filter the visualization or page by removing the blank because it will "remove" J and K from the table.

[sd782]

@BordalosThank you for your inputs. I was able recreate and verify what you said.

[DataDork]

Can you create another product table with just those products and use that for slicer 1 and use the base table for slicer 2?  

What about using a page level filter for products marking it as is not blank?

[SivaMani]

@sd782,

Could you please share sample data?