Hi, I have a file that has store site information that I want to map. I have an issue with how to display these in a map for the following reason. Every store site is a "Test Site" AND that Test Site can also be what is called a "Control Site" that gets compared to a "Test Site" Think of this as a store site (the Test Site) and it's surrounding competitive stores (The Control Sites) around that Test store site. A store site can appear in the Control Store Site column for more than one Test Store Site. Any ideas on how to display this from a map perspective? I do have Lat/Long for each site number is another file. What I want is the ability to select a Test Site and see all the Control Sites for that Test Site with a different coloring for all the Control Sites. I don''t want different colors for each Control Sites. But rather all Test Sites should be 1 color and all Control Sites be another color. Any ideas? Here is my file: Test SiteControl SiteTest ClusterControl Cluster270003927091542227000392701968232700039270084322270003927002432327000392700822232700039270859925270003927028582627000392700755252700039270337825270003927029472127000392700014252700039270160623270114927011986127011492700720622701149270375164270114927016716627011492702893622701149270183262270114927034596527011492701946622701149270162064270114927019856227011492705401662701149270342462270874627033672427087462703395222708746270190824270874627416212227087462741631222708746270156626270874627017502627087462703753262708746270347321270874627066422227087462709191222708746270163322270099027091551227009902709165122700990270128611270099027019481127009902705187112700990270885312270099027417121227009902701356112700990270131011270099027034431327009902701365152700990270664314270665427019576427066542741626622706654270163562270665427057666627066542703419642706654270339464270665427063626427066542702854662706654270175462270665427085556427066542703415642706654270918264270374327066475627037432703487562703743270374654270374327008095227037432741669522703743270666152270374327007335127037432708593542703743270180053270374327085535627037432701317562703743270349551274166527416414227416652709189442741665274163944274166527059544427416652703444422741665270877844274166527417074227416652700761412741665270161344274166527015574227416652708747422741665270860044

Anonymous

Not applicable

5 years ago

Solved

Mapping Stores

Hi, I have a file that has store site information that I want to map. I have an issue with how to display these in a map for the following reason.

Every store site is a "Test Site" AND that Test Site can also be what is called a "Control Site" that gets compared to a "Test Site"

Think of this as a store site (the Test Site) and it's surrounding competitive stores (The Control Sites) around that Test store site.

A store site can appear in the Control Store Site column for more than one Test Store Site.

Any ideas on how to display this from a map perspective? I do have Lat/Long for each site number is another file. What I want is the ability to select a Test Site and see all the Control Sites for that Test Site with a different coloring for all the Control Sites. I don''t want different colors for each Control Sites. But rather all Test Sites should be 1 color and all Control Sites be another color.

Any ideas?

Here is my file:

Test Site	Control Site	Test Cluster	Control Cluster
2700039	2709154	2	2
2700039	2701968	2	3
2700039	2700843	2	2
2700039	2700243	2	3
2700039	2700822	2	3
2700039	2708599	2	5
2700039	2702858	2	6
2700039	2700755	2	5
2700039	2703378	2	5
2700039	2702947	2	1
2700039	2700014	2	5
2700039	2701606	2	3
2701149	2701198	6	1
2701149	2700720	6	2
2701149	2703751	6	4
2701149	2701671	6	6
2701149	2702893	6	2
2701149	2701832	6	2
2701149	2703459	6	5
2701149	2701946	6	2
2701149	2701620	6	4
2701149	2701985	6	2
2701149	2705401	6	6
2701149	2703424	6	2
2708746	2703367	2	4
2708746	2703395	2	2
2708746	2701908	2	4
2708746	2741621	2	2
2708746	2741631	2	2
2708746	2701566	2	6
2708746	2701750	2	6
2708746	2703753	2	6
2708746	2703473	2	1
2708746	2706642	2	2
2708746	2709191	2	2
2708746	2701633	2	2
2700990	2709155	1	2
2700990	2709165	1	2
2700990	2701286	1	1
2700990	2701948	1	1
2700990	2705187	1	1
2700990	2708853	1	2
2700990	2741712	1	2
2700990	2701356	1	1
2700990	2701310	1	1
2700990	2703443	1	3
2700990	2701365	1	5
2700990	2706643	1	4
2706654	2701957	6	4
2706654	2741626	6	2
2706654	2701635	6	2
2706654	2705766	6	6
2706654	2703419	6	4
2706654	2703394	6	4
2706654	2706362	6	4
2706654	2702854	6	6
2706654	2701754	6	2
2706654	2708555	6	4
2706654	2703415	6	4
2706654	2709182	6	4
2703743	2706647	5	6
2703743	2703487	5	6
2703743	2703746	5	4
2703743	2700809	5	2
2703743	2741669	5	2
2703743	2706661	5	2
2703743	2700733	5	1
2703743	2708593	5	4
2703743	2701800	5	3
2703743	2708553	5	6
2703743	2701317	5	6
2703743	2703495	5	1
2741665	2741641	4	2
2741665	2709189	4	4
2741665	2741639	4	4
2741665	2705954	4	4
2741665	2703444	4	2
2741665	2708778	4	4
2741665	2741707	4	2
2741665	2700761	4	1
2741665	2701613	4	4
2741665	2701557	4	2
2741665	2708747	4	2
2741665	2708600	4	4

Need Help

Greg_Deckler

5 years ago

Anonymous I fixed it like this:

Promo1 = 
ADDCOLUMNS(
    UNION(
        SUMMARIZE('Promo',[Test Site],"Control Site",[Test Site],"Test Cluster",MAX('Promo'[Test Cluster]),"Control Cluster",MAX('Promo'[Control Cluster])),
        'Promo'
    ),
    "Legend",IF([Test Site] = [Control Site],"Test","Control")
)

Updated PBIX is attached below sig.

PromoAsstClusters.pbix1.5 MB

Greg_Deckler

5 years ago

Anonymous Technically it is not. The problem is that the numbers are very close to one another so Power BI is color coding them nearly the same. This is the problem I was referring to. Try this:

Promo2 = ADDCOLUMNS( UNION( SUMMARIZE('Promo',[Test Site],"Control Site",[Test Site],"Test Cluster",MAX('Promo'[Test Cluster]),"Control Cluster",MAX('Promo'[Control Cluster])), 'Promo' ), "Legend",IF([Test Site] = [Control Site],2^[Test Cluster],2^[Control Cluster]) )

Forum Discussion

Mapping Stores

21 Replies

Related content

Stored Procedure to Manipulate Tables

Filled map

Shape map

regarding storing multiple tables in lake house

Map and filled map visuals are disabled