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 Don't need the disconnected slicer then or the Complex selector. You could create a measure like HASONEVALUE('Table'[Control Site]),1,0) and use that for a color?
I am still having a hard time simply trying to filter to a test site and just see that test site and the control sites that compete with that test site. Something as simple as this is perplexing me. Can I upload my .pbix?
Anonymous Sure.
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.