Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to 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.
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
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.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |