Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Turambar
Frequent Visitor

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?

 

IDNameAnimalTypeDistance
1DaffyDuckBird5
2White FangWolfMammal25
3SlyFoxMammal10
4HedwigOwlBird3
5LizIguanaReptile7
6KermitFrogAmphibian10

 

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.

1 ACCEPTED SOLUTION
mangaus1111
Solution Sage
Solution Sage

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.

View solution in original post

3 REPLIES 3
mangaus1111
Solution Sage
Solution Sage

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

bcdobbs
Community Champion
Community Champion

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.

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors