Forum Discussion
Table not showing all values from map
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.
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"?
Some of the columns do have blank values, but I have tried enabling "show items with no data" and that did not resolve the issue. When I show the map as a table, all of the data is there (removed names for privacy).
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.