Dynamically selecting the most recent value for each category

[Anonymous]

I'm trying to create a filled map that shows the current Governor's party affiliation for each state at any given time (controlled using a slicer). The map shown below uses 'State' for Location and 'Party' for the Legend.

Solutions I have tried:

1) Simply applying a slicer

I think this could work, however, the legend works alphabetically and can't be changed to date (that I'm aware of). Thus, if in the given range for a state, there were democratic and republican governors, then the map will show blue for the democratic one as it comes first alphabetically regardless of which came first/last.

2) Creating calculated tables:

Table 1: Latest = summarize(all_states, all_states[State], "Took office", MAX(all_states[Took office]))

Table 2: Most Recent Values = SUMMARIZE( FILTER(CROSSJOIN(all_states, Latest), all_states[State] = Latest[State] && all_states[Took office] = Latest[Took office]), all_states[State], all_states[Governor], all_states[Party], all_states[Took office], all_states[Left Office])

This will give me the current (latest date for each state regardless of slicers) information for each state, but it isn't date sliceable as the slicer is applied to the "Most Recent Values" table instead of its source table.

3) You can't create a measure for each state individually as the map only accepts a single column for the legend.

Mini subset of data (Alabama, Alaska, and Arizona from 1/1/2000 - 1/14/2020 [Took office dates]):

State	Governor	Party	Took office	Left Office
Alaska	Mike Dunleavy	Republican	12/3/2018	11/5/2020
Alabama	Kay Ivey	Republican	4/10/2017	11/5/2020
Arizona	Doug Ducey	Republican	1/5/2015	11/5/2020
Alaska	Bill Walker	Independent	12/1/2014	12/3/2018
Alabama	Robert J. Bentley	Republican	1/18/2011	4/10/2017
Alaska	Sean Parnell	Republican	7/26/2009	12/1/2014
Arizona	Jan Brewer	Republican	1/21/2009	1/5/2015
Alaska	Sarah Palin	Republican	12/4/2006	7/26/2009
Alabama	Bob Riley	Republican	1/21/2003	1/17/2011
Arizona	Janet Napolitano	Democratic	1/6/2003	1/21/2009
Alaska	Frank Murkowski	Republican	12/2/2002	12/4/2006

[amitchandak]

@Anonymous , Not very clear. But if you are looking for Winner Map, refer to my blog

https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814

In case you need current active then refer to HR Blog, Hope you are using a filter on some time element

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970