Data not coming in Azure Map but in Map Visual

[Surekha_PM]

Hello Everyone,

There is a strange issue that occurred in my dashboard. When I am using a filter in Azure Map, the graph is not showing any data, but the same filter is showing the correct result in the map visual. Below are the details of the data and the screenshot attached.

Formula used:

VAR PPB = IFERROR(CALCULATE(SUM(Table_V3[PPCount]),'Table_V3'[IsCom] = 0,
Table_V3[RowID] <> BLANK(),
REMOVEFILTERS(Comp[ComOnly]),
REMOVEFILTERS(Comp[SubB])
),0)
VAR PPCOMP = IFERROR(CALCULATE(SUM(Table_V3[PPCount]),'Table_V3'[IsCom] = 1,
Table_V3[RowID] <> BLANK(),
REMOVEFILTERS(B[BOnly]),
REMOVEFILTERS(B[SubB])
),0)
VAR BProd = IFERROR(CALCULATE(SUM(Table_V3[OrgCount]),'Table_V3'[IsCom]=0,
Table_V3[RowID] <> BLANK(),
REMOVEFILTERS(Comp[ComOnly]),
REMOVEFILTERS(Comp[SubB])
),0)

VAR TotalPP = PPB+PPCOMP

RETURN(BProd/TotalPP)

The above formula is being used. Now when I am applying Comp[ComOnly] and Comp[SubB] filters, the Azure map is not showing any data, but the map visual is showing. 

Azure Map Visual

Map Visual

Can anyone help us to understand the issue?

Regards,
Surekha

[v-pnaroju-msft]

Hi Surekha_PM,

We are following up to see if the issue is resolved. If it is not resolved, send a simple PBIX file with sample data, and make sure to remove or replace sensitive information. Share a link to the file where the Azure Map visual remains blank.

If you need more help, contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Surekha_PM,

We are following up to know if the issue is fixed or not. If the problem still exists, please share a simple PBIX file with sample data. Make sure to remove or replace any sensitive information. Please provide the file through a sharing link where the Azure Map visual still shows a blank result.

If you have any more questions, feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi Surekha_PM,

Thank you for your update.

As the earlier steps have not resolved the issue and you are still encountering the problem, we kindly request you to provide a simplified PBIX file containing sample data, with any sensitive information replaced. Please share the file via a file sharing link where the Azure Map visual continues to display the blank result.

Should you have any further queries, please feel free to reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Surekha_PM,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[Surekha_PM]

Hi @v-pnaroju-msft,

The issue is still not resolved. I am still working on it to understand the correct issue. I will let you know once the issue is resolved.

Thanks!
Surekha Prasad

[v-pnaroju-msft]

Thankyou, @jaineshp, for your response.

Hi Surekha_PM,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

In addition to the response provided by @jaineshp , please find below some additional checks that may affect Azure Map rendering:

1. Please verify the Power BI tenant settings for Azure Maps. If Azure Maps is disabled at the tenant level, the visual will not display data, even if the DAX and configuration are correct.
2. Azure Maps relies on correct data categorization to interpret location fields accurately. In Data View, select your location column, then go to Column Tools and in Data Category, set it to City for city names, Country or Region for countries, and Latitude or Longitude for coordinates.
3. Even minor data quality issues can prevent plotting. Kindly remove blanks, correct spellings, and use full names such as United States instead of USA. For cities with common names, please include the country or state in the location field.
4. If the wrong map layer is active, points might not appear. In the Format pane, navigate to Layers and ensure that the Bubble layer or the intended layer is enabled.

Additionally, please refer to the following links:
Get started with Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn
Data categorization in Power BI Desktop - Power BI | Microsoft Learn
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn

We hope the information provided will help resolve the issue.
Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[jaineshp]

Hey @Surekha_PM,

Appreciate your feedback!

Since you're still not seeing data in the Azure Map, the issue is likely not just with the DAX formula but with fundamental Azure Map configuration or data binding. Here are the most critical things to check immediately:

Priority 1: Azure Map Visual Configuration

1. Field Mapping: In Azure Map, your measure must go in the "Size" field, not the "Values" field like other visuals
2. Location Field: Your geographic column (country, state, city) must be properly mapped to the "Location" field
3. Auto Zoom: Enable this in Format → Map Settings

Priority 2: Quick Test

Create this simple test measure first:

Test_Simple = SUM(Table_V3[PPCount])

If this simple measure doesn't show in Azure Map, the issue is with visual configuration, not your complex DAX.

Priority 3: Geographic Data Validation

Check if your location data is in the correct format:

• Country names should be full names (e.g., "United States" not "USA")
• Make sure there are no blank location values where you expect data

Can you please test the simple measure above and let me know:

1. Does it show data in a regular Table visual?
2. Does it show data in Azure Map?
3. What type of geographic data are you using (country names, coordinates, etc.)?

This will help me pinpoint exactly where the issue lies!

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

Best regards,
Jainesh Poojara / Power BI Developer

[jaineshp]

Hey @Surekha_PM ,

Based on your issue description and the screenshots provided, here's a comprehensive analysis and solution for the Azure Map vs Map Visual data discrepancy:

Key points to focus on for immediate resolution:

1. Replace REMOVEFILTERS with ALL() - Azure Map has better compatibility with ALL() functions
2. Simplify the measure structure - Break down complex calculations into smaller, manageable components
3. Use DIVIDE() function - This handles zero division scenarios more reliably
4. Verify geographic data binding - Ensure location fields are properly mapped in Azure Map

The step-by-step implementation guide should help you resolve this issue systematically while maintaining data accuracy across both visual types.

// Alternative Version with more explicit error handling
VAR PPB =
IF(
ISBLANK(CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))),
0,
CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))
)

VAR PPCOMP =
IF(
ISBLANK(CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 1, Table_V3[RowID] <> BLANK(), ALL(B[BOnly]), ALL(B[SubB]))),
0,
CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 1, Table_V3[RowID] <> BLANK(), ALL(B[BOnly]), ALL(B[SubB]))
)

VAR BProd =
IF(
ISBLANK(CALCULATE(SUM(Table_V3[OrgCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))),
0,
CALCULATE(SUM(Table_V3[OrgCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))
)

VAR TotalPP = PPB + PPCOMP

RETURN
IF(TotalPP = 0, 0, BProd / TotalPP)

Testing Steps:

1. Apply the first modified version in your Azure Map
2. Test with the same filters (Comp[ComOnly] and Comp[SubB])
3. If issues persist, try the alternative version
4. Compare results with your working Map Visual to ensure accuracy

The primary modification (replacing REMOVEFILTERS with ALL) should resolve the Azure Map data display issue while maintaining the same calculation logic.

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

Best regards,
Jainesh Poojara / Power BI Developer

[Surekha_PM]

Hi @jaineshp,

Thank you for your quick response. I tried to follow the steps you suggested, but I still can't see the data in Azure Map. Is there any setting that I need to enable?