Forum Discussion
Mapping Stores
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 Sure.
SWEET. Thank you Greg_Deckler
Greg_Deckler How about if we take the original solution you provided below and make a new Column for Test/Control Cluster for color coding? How would I modify 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")Greg_Deckler Okay, I see that now with this new one and the purplish colors. I guess I am going to have to go back to the drawing board on this to see how best to visualize it. Thank you!
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.
Greg_Deckler How can I now make this legend be able to do color coding like you have already done for me based on Test Site or Control Site (Red & Blue) and introduce Selecting multiple Test Clusters like Cluster 1 and 2. This would then hopefully be able to show 4 different colors?
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.
Anonymous You would modify the part after "Legend". IDK, the issue is getting a different enough color for each thing you want. If the values are similar, Power BI picks similar colors.
What I was asking was to instead do the color coding on the Site's like you provided me in the original code, change it to Cluster.
Here is your code for Site coloring:
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")When I try to create a new Promo2 table with the following:
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 Cluster] = [Control Cluster],"Test","Control"))It has the same color coding of 2 colors as for site. I was expecting different colors for each different cluster # from 1 to 6?Anonymous Try:
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],[Test Cluster],[Control Cluster]) )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]) )If you need any help with ArcGIS, drop a line and myself or one of the developer will help out.