Forum Discussion
Solved
How to filter by value but keep blanks?
We are trying to use a slicer that will return rows with the selected value OR blank. For example: in the table below, a slicer that targets department and selects "Admin" would need to return t...
Hi mtalbottasg
You can create disconnected table :
And a measure for filtering
Test = IF( SELECTEDVALUE('Table'[Department]) = "",1,IF(SELECTEDVALUE('Table'[Department]) in VALUES('slicer table'[Department]),1,0))Then use a slicer table for a slicer :You can filter out the blank if you need :
And create a table from the original table's fields with the test measure as a filter:
Result :
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983
Super User
Super UserHi mtalbottasg
You can create disconnected table :
And a measure for filtering
Test = IF( SELECTEDVALUE('Table'[Department]) = "",1,
IF(SELECTEDVALUE('Table'[Department]) in VALUES('slicer table'[Department]),1,0))
Then use a slicer table for a slicer :
You can filter out the blank if you need :
And create a table from the original table's fields with the test measure as a filter:
Result :
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly