Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
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!
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
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.
@greggyb I'll do that.Thanks!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
85 | |
78 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |