Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
DuncanP
Advocate II
Advocate II

Map legend limitations?

Hi

 

I'm trying to create a simple map report that shows locations of customers from CRM (I'm using the content pack). I'd just like to add a legend to the map that shows the names of the customers, but have run into an issue.

 

I use the postcode to plot the locations of the customers, and a count of name (which is always 1), which shows all of them on the map. However, when add the account name as a legend, the number of customers shown always drops to 12. Any other chart type with the same data shows all customers in the legend so it's just the map plot that limits legend items to 12.

 

Am I doing something wrong, or is there a limitation that I don't know about?

 

Duncan

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

I was able to get more than 12 in my legend on both filled map and map visualizations



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

That's great. So I must be doing something wrong then, but what I wonder?

@DuncanP - Any way you can post some data by which to recreate the issue. Or, can you post a screen shot of your map with your settings for Axis and such showing so that we can see how you have it configured.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler I think I have the same issue as @DuncanP. To simplify things, I am plotting Sales Values by UK Postcode. The below configuration works as expected: All post codes are plotted and the bubbles are sized by sales value.

Working Config

The issue comes in when I add the Territory to the legend. Many of the ostcodes are not Plotted as you can see in the image below:

Failed Config

 

Here's some info that might help:

The table has sales on the row level. Each sale has a postcode and a territory. The postcode is categorized as a postal code and the territory is a text field.

 

Why would adding the territory field to the legend plot fewer postcodes? I am expecting it to just color the postcodes.

---

Update:

The legend by itself is not the issue in that when I remove value, it correctly colors all the bubbles and when I remove territory, it correctly sizes all the bubbles. Is there a limitation on the amount of points using the legend and the size. It is only when I do both of these that there is an issue. Reference Image below:

Comparison Example 

---

 

P.S. Where can I host an image so I can insert it directly into a reply? Whats the best way to do this?

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Solution Authors