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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
Super User
Super User

@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!:
The Definitive Guide to Power Query (M)

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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.