Forum Discussion
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 ...
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.
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]) )
Anonymous Hmm. Well, Color in ArcGIS can be a measure. So I suppose you in theory do something. I think the problem you will run into is around figuring out the right context. Also, need to get enough color variation. It would be very tricky. Maybe:
Measure =
VAR __TestStore = MAX('Promo1'[Test Site])
VAR __ControlStore = MAX('Promo1'[Control Site])
RETURN
IF(ISBLANK(__TestStore),BLANK(),IF(__TestStore = __ControlStore,__TestStore,__TestStore-2700000))
Hi Greg_Deckler
I will work with this.....but it doesn't need to be ARGIS map. I can use any of the mapping options.
If you need any help with ArcGIS, drop a line and myself or one of the developer will help out.