Forum Discussion
Power BI Map - Missing data based on Legend
I have Used Power Bi map and Querying the data based on the filters in slicers. After applying the filters, i am missing some values (out of 58 - 2 values for now) missing in Power Bi Map Visual - (I am able to identify the missing records by exporting the Power BI map visual data to table and comparing the same data with Power BI Table Visual using the same filters).When i use same data filters to the Table Visual, i am able to see the missing records in the Visual.
Verified if there any spaces/Special charecters in the column data added in legend. It is not different from others
When i change the Legend column in Power BI Maps, i am able to see the data as expected (no missing records in the map). Can anyone help me what causing the issue here?
7 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi lbendlin ,
Yes, Here are details.
I have a map visual applying the filters using slicers dataCreated Table Visual using Same filters and Data source in a different page (Slicers are in sync with two pages)
When we try to Export the data from Map Visual and Table visual i see some rows are missing form the data exported from Maps. After checking some time, replacing legend column with other column, i am able see the same data after Export from two visuals. But we need the same column as legend.
i see there is no issues with legend column data. (no spaces, No special charecters). Can anyone help me here reason for the issue?Are you geocoding based on addresses or on Lat/Lon coordinates?
Hi lbendlin ,
No i didn't use the geo coding. Just FYI.., i have followed the video below.
https://www.youtube.com/watch?v=n5Uip9mhSkA&t=600s
I found the same issue where some of my locations were not showing on the map. I found that when I removed the "Title" of the location from the Legend, then every location would show without issue. When I put the legend back, some of the locations would dissappear. Not sure why but I chose to not use the legend. The only difference is that the legend shows all locations with different colors where without a legend everything is the same color.
