Empty values are missing from Slicer options

[Anonymous]

Hello

In the attached pbix, the slicer has only the value 'A' as an option while the table has some empty values.

Is it possible to make the slicer have the empty value as an option? I want to only show the rows with the empty values.

https://ufile.io/9gmho4r8 

Thanks

[Anonymous]

Hi @Anonymous ,

I did some test and found that the blank slicer will appear only when you are not using many to many relationship.

Best Regards,

Jay

[amitchandak]

@Anonymous , if you have blank value, slicer will have blank option

[Anonymous]

@amitchandak  thanks, it does not have blank value, it has an empty value resulting from not being able to find a match in the joined columns.

How can I select these rows with the slicer?