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]) )

     

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 

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

 

Click Here 

  • 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!

  • 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]) )