Copy Table For Comparison Visual

[jsuttmann]

I need to compare the sales data for two locations.  I have a table of sales data (SALES) linked to a table of locations (LOCATIONS).  My goal is to have two slicers for the first location and the comparison location.  For the comparison location, in the Data tab, I created a new table (LOCATION_COMPARE) via a DAX function:  LOCATION_COMPARE = LOCATIONS.  Then on the Model tab, I linked LOCATION_COMPARE to SALES and added the second slicer using LOCATION_COMPARE.  However, when I select a location from either slicer, it updates the other slicer as well.  How can I have two separate tables and slicers of locations linked to the same sales data where the two location slicers are completely independant and don't impact each other?

[amitchandak · Accepted solution]

@jsuttmann , for that you need two location tables join with your table 1. one independent location another one can be joined on independent

I do not have an example for categorical data for this. But have for date. Please refer if that can help

How to use two Date/Period slicers :https://www.youtube.com/watch?v=WSeZr_-MiTg