Forum Discussion
PowerBI Map View Filtered along side with Unfiltred Data
Hello Everyone
I'm struggling with this I don't know how to achieve it.
So Basically I have a map with bubbles in it
Everything Normal at this point.
What I need to do is when I filter using any of my slicers, I need the map to highlight the filtered data but also to show the other bubbles.
(Screenshot below is when I apply a slicer filter) the map is also filtered and only one bubble remains, I want the others to stay even the same way when I click on a bubble on the map. ( Second screenshot bellow)
Any help will be appreciated, thanks in advance.
Hi AmineGatou ,
You will need to create an indenpenet slicer table like below:
slicer = distinct('table'[locations])
Then create a measure like below and add it to conditional formatting value.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Measure = IF(SELECTEDVALUE('Table'[location]) in VALUES('slicer'[location]),"red","green")
Best Regards,
Jay
Hi AmineGatou ,
If you have other slicers, add the filter conditions to the measure.
Measure = IF(SELECTEDVALUE('Table'[location]) in VALUES('slicer'[location]&&'table'[column] in Values('slicer2'[column])),"red","green")
Best Regards,
Jay
12 Replies
Hi AmineGatou ,
You will need to create an indenpenet slicer table like below:
slicer = distinct('table'[locations])
Then create a measure like below and add it to conditional formatting value.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
Measure = IF(SELECTEDVALUE('Table'[location]) in VALUES('slicer'[location]),"red","green")
Best Regards,
Jay
Great! It works but with the location slicer only !
But if I use another slicer it won't work at all.
Hi AmineGatou ,
If you have other slicers, add the filter conditions to the measure.
Measure = IF(SELECTEDVALUE('Table'[location]) in VALUES('slicer'[location]&&'table'[column] in Values('slicer2'[column])),"red","green")
Best Regards,
Jay
- vanessafvg
Community Champion
there are several maps in power bi, which one are you using? also what you have plotted, please provie more information.
Hello, The map type used is just the regular map of powerbi
and i'm plotting the sales Measure depending on regions!- vanessafvg
there is no regular one, which one are you using, in order for help to be given, you need to give the details.
