Forum Discussion

ejhornyak's avatar
ejhornyak
Frequent Visitor
8 years ago

Mapping Cumulative Locations

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 fil...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
ejhornyak
Frequent Visitor
8 years ago

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's avatar
    ejhornyak
    Frequent Visitor
    8 years ago

    I can right the formula in Excel to say

     

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

     

    Just not sure how to write that in DAX

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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