How to filter out Blank value from the slicer?

[Anonymous]

How to filter out Blank from Week number slicer?

[v-shex-msft]

HI @Anonymous ,

This scenario should be related to relationship mapping when your tables contain not match records.

Reference link:

Slicer showing Blank as a value when data does not have any blank values 

For your scenario, you can extract two tables relationship key value to create a new table as bridge, then link original table based on this bridge table and create slicer with new table fields to display all item and filter on two tables records:

Bridge =
DISTINCT ( UNION ( VALUES ( Table1[Column] ), VALUES ( Table2[Column] ) ) )

Regards,

Xiaoxin Sheng

[KEITHO · Accepted solution]

It would be more effective to use the advanced filter and select is not blank.

This will future proof your report, in case you have more values than [A,B,C] in future. Otherwise your report will exclude new values based on Tahreem24's response.

Filter away blank values

[Tahreem24]

Hi @Anonymous ,

Go to Filter Pane and deselect the blank from Week column. (Screen shot is attached)

[Tahreem24]

Hi @Anonymous ,

Please give KUDOS for Support and also accept this as a solution if you find it helpful!

Good Luck!

Thanks!