- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change Bubble Map Legend based on Filter/Slicer (from 3 different columns)
Hello,
Without knowing if this is even possible, I would like to make sort of a dynamic bubble map based on filter selections (either from a slicer og visual filter in the filters pane).
The Case
I have 3 measure in the same dataset that tells the sales person essentially the same thing, but about 3 different product groups. The measures looks into if the location is able to perform a service we have in our value proposition (so we have 3 services offers and want to show for each of these locations if we can perform the service or not).
Now, what I would like is to create a filter or slicer that enables the sales person to choose between 1 of these service offers with the map automacially updating based on this selection.
So, let's say that the employee is preparing for a customer meeting and want to look into our location offering the service for product 1 - he/she selects product 1 in the filter, and the bubble map shows the location that are able to service in green, and those that are not in black. Next, they want to do the same for product 2 - so he/she selects product 2 in the filter, and the bubble map is updated with again with green/black if they can perform the service or not.
Is it possible to do this by using a DAX formula to create the filter?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Right, so you would overlay the same visual over top of one another with the different filters or settings that you want. You would use the Selection pane to create bookmarks where one of the visuals is visible but the others are not. You then tie the buttos to the bookmarks.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would look into using buttons and bookmarks for what you want to do.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Greg_Deckler ,
Thank you for the prompt reply.
Can I make you elaborate a bit further on how to do this? I am still relatively new to the whole Power BI-development.
I know how to make bookmarks to navigate from one page to another based on a button linking to a specific page. But I would like if it is possible to have the map only on one page, and then having this updated based on the "filter" choosing to show data for either Product 1, 2, or 3.
Best,
SHS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Right, so you would overlay the same visual over top of one another with the different filters or settings that you want. You would use the Selection pane to create bookmarks where one of the visuals is visible but the others are not. You then tie the buttos to the bookmarks.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-10-2024 11:18 AM | |||
Anonymous
| 01-10-2024 03:52 PM | ||
01-17-2024 11:27 PM | |||
07-09-2024 01:42 AM | |||
05-30-2024 04:44 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
11 | |
8 |