Forum Discussion
Anonymous
3 years agoNot applicable
Filter with Blank option
My filter has a blank option.
It happens because some values are in one of the worksheets and not in the other. The filter is pulling from worksheet X and the values are from worksheet Y.
I wanted to know how to make the filter work even without having to include information from one worksheet in another.
1 Reply
- amitchandak
Super User
Anonymous , Is worksheet X and Y related in power bi?
You can use a visual level filter to ignore it.
Refer this video if needed - why blank values -https://www.youtube.com/watch?v=23qemkDqMVY