Forum Discussion
Solved
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 matte...
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.
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.