Show non selected points on map

[Pedro503]

Hey guys.

I have a map where it displays all the points that have some data linked to the place. However, what I'd like to do is to also show all the other points that have not been filtered, using a grey color, for instance. Here I've zoomed in on the Europe region, so, as expected, all points are shown because there's no filter applied. However, when I filter Germany and France (as the next picture shows), all other countries then are no longer highlighted with the blue bubble.

Picture 1: what I've got when no filter is applied

 Therefore, I aim to make all the non selected points to be shown as grey (or whatever other color I want to).

Picture 2: what I've got now

Picture 3: what I'd like to have

Any thoughts?

File link here.

( @SpartaBI @amitchandak you all have helped me before on other topics, do you know how I can do that? Thanks in advance)

[Pedro503]

@v-stephen-msft , I think that it's possible to do what I aim by creating a condition that computes the sum if the slicer is filtering the country (or the city), otherwise, it will just show the number 0.1. Then I could use conditional formatting that if the number is 0.1 the bubble color will be grey, however if it is greater than or equal to 1 the color will be blue.

I've tried to calculate it by creating something like this

var soma = SUMX(F_Rotas, F_Rotas[sum(cuid)] * 1) 
var condicao = 
    IF(ISFILTERED(F_Rotas[l.user_country]) = TRUE(), -- is the slicer filtering the country?
                  soma,                              -- if true, then compute the sum
                  0.1)                               -- otherwise, just show 0.1
return condicao

however, when I apply any filter whatsover only the filtered countries are shown on the map.

Any thoughts on where I'm doing wrong in this formula?

[v-stephen-msft]

Hi @Pedro503 ,

Sorry, but there is currently no such feature.

You may submit the idea for it:

https://ideas.powerbi.com/ideas/

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pedro503]

Thanks for your response.

What a pity 😕