Mapping Cumulative Locations

[ejhornyak]

I am trying to map my companies locations and show our growth over time.  I am mapping my locations by Lat, Long.

I can use the Play Axis visualization to filter through years, but I want the filter to be able to play through and leave the previous locations but add the new locations for the next year to the map.

Example Map shows all locations from 2014 but when the filter plays to show 2015 I want the map to now show 2014 and 2015 locations.

Is there a key or calculated column I could add and use that in the Play Axis visualization?

[v-shex-msft]

Hi @ejhornyak,

Nope, current power bi map visual not support this, if you choose 2015, it only show 2015 locations.

I'd like to suggest you write a measure to check date and add tag, then drag this tag measure to visual level filter to achieve the filter effect. (filter can't direct effect the map visual, use measure to get value from filter, and use it as parameter to calculate in measure)

Sample:

Tag =
VAR selectedValue =
    SELECTEDVALUE ( Calendar[Year] )
VAR current_date =
    MAX ( table[date] )
RETURN
    IF ( YEAR ( current_date ) IN { selectedValue, selectedValue - 1 }, 1, 0 )

Drag to visual level filter to filter records with result '1'.

Regards,

Xiaoxin Sheng

[ejhornyak]

Thanks for the help.  

I was able to get the TAG measure to work correclty to apply a number to the year.  

But what I would like to do is use the Play Axis Visual to play through the years and locations cumulatively show on the map. 

So what I would need is the tag measure to add a 1 to all of the years less than what the date filter would be. 

[ejhornyak]

I can right the formula in Excel to say

=if(Year<= Selected Year , 1, 0)

Just not sure how to write that in DAX

[v-shex-msft]

Hi @ejhornyak,

Maybe you can try to use below formula:

Tag =
VAR selectedValue =
    SELECTEDVALUE ( Calendar[Year] )
VAR current_date =
    MAX ( table[date] )
RETURN
    IF ( YEAR ( current_date ) <= selectedValue, 1, 0 )

Regards,

Xiaoxin Sheng