Forum Discussion
Slider to filter only specific rows
I have a map visual with a bubble on each ID and Animal on legend. What I want to do is have a slider on Distance but have it only affect Type = Mammal. All other types should always display no matter what the slider is at but then for mammal only those within the range will show. Is this possible?
| ID | Name | Animal | Type | Distance |
| 1 | Daffy | Duck | Bird | 5 |
| 2 | White Fang | Wolf | Mammal | 25 |
| 3 | Sly | Fox | Mammal | 10 |
| 4 | Hedwig | Owl | Bird | 3 |
| 5 | Liz | Iguana | Reptile | 7 |
| 6 | Kermit | Frog | Amphibian | 10 |
As an example, if the slider is set for 7-15 then ID 3 should be the only mammal on the map while all other types of animals show regardless of what the slider is set to.
Hi Turambar
yes, it is possible. See my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi2PP4MyWeGJxZo3L?e=AnwkRI
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
You would need a disconnected table with the values in for the slicer.
Use that to build the slider which won't do anything to start with.Then write a measure that returns 1 for rows to include and 0 for rows to exclude which reads the VALUES from the disconnected table and the SELECTEVALUE of the type.
You can then use that measure as a visual filter.
I can build a demo for you tomorow
if you need.
Hi Turambar
yes, it is possible. See my pbi file
https://1drv.ms/u/s!Aj45jbu0mDVJi2PP4MyWeGJxZo3L?e=AnwkRI
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for putting this together, I just tried it out and the slider is working exactly how I wanted on the table. I'll test it out on the real report to see if it works on the map as well but I think you've solved it
