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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!