Forum Discussion
Post PartisanMap 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 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.
5 Replies
- amitchandak
Super User
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
AvivekHi 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.
- 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.
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).
