Forum Discussion

Anonymous's avatar
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 ...
Need Help
  • Greg_Deckler's avatar
    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.

  • Greg_Deckler's avatar
    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]) )

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 

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?
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

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

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

    Greg_Deckler 

    That gives me all 1 color for everything. Here is updated .pbix

     

    Click Here 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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]) )