Forum Discussion
Legend with dynamic data in Shape MAP
kushanNa
Okay, it seems that i'd created my own problem.
The original thing, as described in this topic and with above measures, does do the trick.For some reason, the issue had experienced was due to the fact that I'd checked Show items with no data for the origin. (I had that checked from an earlier version where I'd tried to give a color to the "empty" shapes)
I do not understand why, but unchecking this setting does the trick and shows me what i need!
Thanks for your help!
Hi tjalleph
do you have a special requirement to create the _traveltime_category as a measure ?
If not have you tried to creating it as a calculated column in TimeTravel table and use it as legend ?
No, I don't need to use this measure.
The issue with a calculated column is that I want to be able to dynamically filter the map (for example, selecting certain destinations). I've use a calculated column, I'm not able to get the minimal travel time dynamically.
I've tried summarizing into a new table, but that gives the same issue: i'm not able to get this to work dynamically with slicers/filters.
tjalleph Filter the locations in your main table that are coming up as blank and check if there are any blank values, errors, spaces or unusual formats ?
kushanNa No, they're not empty.
See the two figures side-by-side. Both are unfiltered, meaning that all shapes have (multiple) datapoints of travel time. I can't find a pattern in this behavior neither: shapes stay empty that have - in the table - all datapoints of the same "traveltime_category" [e.g. "<15min"], or when there are different traveltime_categories for an origin.
see also example below of the filtered dataset.tjalleph it seems like shapemap has a datapoint limit 1500 https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-data-points maybe this can be a reason