Map is not filtering the data

[Avivek]

Its the first time I am using the map in power bi. It seemed to work fine in general but when I applied filter to it the data is not showing in the map. Without filtering-

But when a filter is applied it either shows only US or it does not show at all. Can someone please tell me the reason for this and if there is a fix for it.

[Anonymous]

Hi @Avivek 

What filter conditions did you put on the report level filter ?

Best Regard

Community Support Team _ Ailsa Tao

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

[Avivek]

Hi, @Anonymous , I have used this on a visaul level filter-Is DeltaValue = IF([From Sales Amount]+[To Year Sales]+[YOY Sales Growth details %]=0,0,1).

[amitchandak]

@Avivek , is there some issue with the country name. May be city name is working and not the country name. Check if country name is working on visual

[Avivek]

I can see this issue with the filled map and not the maps. So, if it was data issue then should be a problem in maps and filled maps as well. Now I know what is happening but I do not know what is happening.

[Avivek]

Hi @amitchandak , there is a visual level filter applied to the map & the table,                                                         Is DeltaValue = IF([From Sales Amount]+[To Year Sales]+[YOY Sales Growth details %]=0,0,1)

This is used so that the countries which are blank do not appear.

If the measure is given as 1 on a visual level filter and DIvision is selected then although the table is showing values but the filled map shows only US.

However, if we select just maps then the other countries are also shown.

aLSO 

Also if we remove the measure as 1 from visual level filter then the other countries also appear. So I am not sure how it is filtering and why this bug appears.