Forum Discussion
Can I create filter with overlapping values?
Hello data heroes!
I would like to ask if there is a possibility to create filter with overlapping values? Let's say, I have a table with cars and their statuses:
| CarID | Status |
| 1 | Rent |
| 2 | Rent |
| 3 | Broken & Rent |
| 4 | Broken & Vacant |
| 5 | Vacant |
| 6 | Vacant |
Do you think, that it is possible to create single filter with three buttons / selectors, working as below?
* Clicking on Rent will return cars with id 1, 2 and 3.
* Clicking on Broken will return cars with id 3, 4.
* Clicking on Vacant will return cars with id 5, 6.
Thank you! All the best,
rakunn
Hi rakunn,
You should have a single table to list all available slicer selections.
Create a measure. And add it to visual level filter, set its value to 1.
Check_Measure = IF ( ISERROR(FIND(SELECTEDVALUE ( Table7[Column1] ) ,LASTNONBLANK(Table6[Status],1 ))), 0, 1 )
Best regards,
Yuliana Gu
1 Reply
Hi rakunn,
You should have a single table to list all available slicer selections.
Create a measure. And add it to visual level filter, set its value to 1.
Check_Measure = IF ( ISERROR(FIND(SELECTEDVALUE ( Table7[Column1] ) ,LASTNONBLANK(Table6[Status],1 ))), 0, 1 )
Best regards,
Yuliana Gu