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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Sean
Community Champion
Community Champion

Map Legend

I have a map with the following:

Location: => County, ST

Legend: => Division 

Values: => Number of Projects (its just a simple counting measure)

 

When you click on a Division in the Map Legend => ALL locations become greyed out - still visible but greyed out.

 

Adjacent visualizations adjust accordingly to reflect data only for this division however ALL locations on the map become greyed out.

 

If I use a Slicer the map zooms in only on that division and they are not greyed out however the rest disappear.

 

I don't get why selecting a Division on the Map Legend filters the adjacent vizualizations correctly but ALL locations become greyed out including the selected Division?

 

Has anyone else encoutered this issue?

 

6 REPLIES 6
Greg_Deckler
Community Champion
Community Champion

@Sean,

 

OK, I tried this with the following data:

 

County,State,Division,Value
Madison,Ohio,Division1,10
Franklin,Ohio,Division2,20
Union,Ohio,Division3,30
Logan,Ohio,Division1,40
Marion,Ohio,Division2,50
Delaware,Ohio,Division3,60

 

I confirmed the behavior. Interestingly, if I only used "State", I got a little pie chart (and I mean little) but when clicking on division in the legend, it greyed out the other divisions parts of the pie and highlighted the one I clicked. Not sure if that is "by design" or a bug but I am seeing the same thing you are.



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...

Thanks for trying it out and confirming!

 

I also encountered another issue when I substituted Division with Deadline in the Map Legend.

 

The Deadline field is Data Type: Date and Formatted: MM/dd/yyyy

 

However in the Map Legend it displays MM/dd/yyyy 12:00:00 AM - I tried every format but can't get rid of the time

 

In a table or a matrix or a slicer the Deadline field displays as intended MM/dd/yyyy

Nice one, so sounds like the map legend is not honoring the format setting, that's interesting to know!



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...

I hope someone from the PBI team addresses this behavior because (or explains why it behaves this way)

 

When you click on an item in the Map Legend you would expect the appropriate items to get highlighted and only the rest greyed out

 

In this case ALL items on the map (including the selected) become greyed out which gives the false impression none are present

 

greggyb
Resident Rockstar
Resident Rockstar

Make sure you submit this as a bug report, as well. You can do so in PBI Desktop by using the 'Send a frown' option in the File menu, and using the feedback menu in PBI Service.

The forums are a great avenue for discussing issues, sharing thoughts / ideas, and troubleshooting, but they are not the official medium to submit bug reports.

Proper bug reports will receive more attention from the devs than forum posts.

Sean
Community Champion
Community Champion

@greggyb I'll do that.Thanks!

@Greg_Deckler 

 

I just discovered that if the Map Legend field is from a related table everything works fine.

 

However if the field is from the same table it doesn't - go figure?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.