Forum Discussion

Avivek's avatar
Avivek
Post Partisan
4 years ago

Map is not filtering the data

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...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
Avivek
Post Partisan
4 years ago

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.