Forum Discussion
Anonymous
6 years agoNot applicable
Empty values are missing from Slicer options
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.
Thanks
3 Replies
- amitchandak
Super User
Anonymous , if you have blank value, slicer will have blank option
- AnonymousNot applicable
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?
- AnonymousNot applicable
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