PowerBI Map View Filtered along side with Unfiltred Data

[AmineGatou]

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.

[v-jayw-msft · Accepted solution]

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

[v-jayw-msft · Accepted solution]

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

[AmineGatou]

Great! It works but with the location slicer only ! 

But if I use another slicer it won't work at all.

[v-jayw-msft · Accepted solution]

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

[houssem33]

What should i do when my location are the longitudes and latitudes its not a single value

[vanessafvg]

there are several maps in power bi, which one are you using?  also what you have plotted, please provie more information.

[AmineGatou]

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.

[AmineGatou]

Here is the one used

[vanessafvg]

you need to probably change your edit interactions and set it to the no filter

once you have selected edit interactions, there will be some filters show top right of every object, then click on the slicer object first, then on your map select no filter

ie 

more information here

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[AmineGatou]

This does help but it isn't what I'm looking for. 
What I mean is that I want my map to be filtered but just to grey out the unfiltered data just like this .

[houssem33]

Hello did you get the solution ? because i have the same problem here 

[AmineGatou]

Unfortunately, i couldn't find a solution to it. Still waiting.