Unable to remove Blanks in Slicer

[h1629]

For "Materialtypecode" column I am seeing blanks

I have already already tried the below solutions 
1. Checked all the facts and Dimentions tables where ever MaterialTypePK or Material type code are nulls or blanks
2.Checked all the relations in the model. All were one -> Many with Single direction filtering

Here is the table stucture of Mterial type Table where in transformations I have removed blanks

[Elena_Kalina · Accepted solution]

Hi @h1629 

1. Check the Number of Blank ValuesAction:

• Select your slicer → open the Filters pane.

• Locate your "Materialtypecode" column → check how many rows are marked as BLANK.

If the count > 0, your data contains hidden blank values that need to be resolved.

2. Create a Diagnostic Table

Goal: Identify under what circumstances blank values appear.

  Create a Manual Table Visual

         1. Add a blank table visual to your report.

         2. Drag these columns into it:

• The "Materialtypecode" column

• Related columns  to identify patterns.

• add a filter in Filters pane to this table ( "Materialtypecode" column is blank)

What this does: shows only rows with blank values, helping you trace their source.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[v-sdhruv]

Hi @h1629 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @h1629 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @h1629 ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[Ritaf1983 · Accepted solution]

Hi @h1629 

If blanks appear in the slicer, it means there's a mismatch between the fact table and the dimension table. This happens when there are values in the fact table that don’t exist in the dimension, even if nulls and blanks were removed in Power Query. It’s usually due to relationship issues or missing keys.

Guy in a Cube has a detailed explanation:
🔗 Why am I seeing (Blank) in my Power BI visuals?

You can filter out blanks directly in the slicer using a visual-level filter, but it’s better to keep checking your model to fix the root cause.

To assist further, it's best to upload a sample PBIX file to a public cloud location and share a link.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Elena_Kalina · Accepted solution]

Hi @h1629 

1. Check the Number of Blank ValuesAction:

• Select your slicer → open the Filters pane.

• Locate your "Materialtypecode" column → check how many rows are marked as BLANK.

If the count > 0, your data contains hidden blank values that need to be resolved.

2. Create a Diagnostic Table

Goal: Identify under what circumstances blank values appear.

  Create a Manual Table Visual

         1. Add a blank table visual to your report.

         2. Drag these columns into it:

• The "Materialtypecode" column

• Related columns  to identify patterns.

• add a filter in Filters pane to this table ( "Materialtypecode" column is blank)

What this does: shows only rows with blank values, helping you trace their source.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.