Forum Discussion
Table not showing all values from map
I have a report built that populates a map and data table based on geographic coordinates and a mile radius. For some reason, not all of the locations on the map are showing up in the data table. In the example attached, there are actually 25 locations on the map, but only 11 are showing in the table. When I click "show as table" on the map, all of the data is there. I have hidden some of the data for privacy reasons. Any help with this would be greatly appreciated!
Hi Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community.
After thoroughly reviewing the details you provided, Your map visual is correctly identifying all 25 points (WithinRadius = 1), so your radius logic is solid.- The “Show as table” feature on the map confirms all expected data is present.
- However, the table visual on your canvas only shows 11 rows, even with "Show items with no data" enabled.
This suggests the table visual may be affected by other data context issues, such as relationships, filters, or how measures behave.
Here are a few steps you can try to isolate the issue:
- Add fields one by one, especially any measures like MAX_ANNUAL_REVENUE, and watch when the row count drops.
- Wrap any measures with COALESCE([Your Measure], 0) or similar to avoid blank values causing row exclusion.
- Check relationships in your model if the table uses fields from related tables, missing keys or inactive joins might filter some out.
- Review visual/page-level filters applied to the table especially filters not used in the map.
Thank you, danextian for sharing your valuable insights.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
3 Replies
Hi Anonymous
Do those tables return blank values? By default, Power BI excludes data points with blank values. Could there be a visual-level filter removing them? Have you tried enabling "Show items with no data"?
Hi Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community.
After thoroughly reviewing the details you provided, Your map visual is correctly identifying all 25 points (WithinRadius = 1), so your radius logic is solid.- The “Show as table” feature on the map confirms all expected data is present.
- However, the table visual on your canvas only shows 11 rows, even with "Show items with no data" enabled.
This suggests the table visual may be affected by other data context issues, such as relationships, filters, or how measures behave.
Here are a few steps you can try to isolate the issue:
- Add fields one by one, especially any measures like MAX_ANNUAL_REVENUE, and watch when the row count drops.
- Wrap any measures with COALESCE([Your Measure], 0) or similar to avoid blank values causing row exclusion.
- Check relationships in your model if the table uses fields from related tables, missing keys or inactive joins might filter some out.
- Review visual/page-level filters applied to the table especially filters not used in the map.
Thank you, danextian for sharing your valuable insights.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
