Slider to filter only specific rows

[Turambar]

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.

[mangaus1111 · Accepted solution]

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.

[Turambar]

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

[bcdobbs]

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.