Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

https://ufile.io/9gmho4r8 

 

Thanks

3 Replies

    • Anonymous's avatar
      Anonymous
      Not 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?

  • Anonymous's avatar
    Anonymous
    Not 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