Unable get Slicer to change data correctly (multi Column)

[BugmanJ]

Hello All,

I have the following simplistic setup:

I want the slicer to be able to slice the top table by the any of the options displayed. The slicer is basically the distinct values of the two columns in the middle table. I have tried creating a measure using switch and selected value which I place on filter, show if equal 1 which worked if i want to change the StoreData table, but it doesnt filter the Location table. If i apply this measure to the Location table, it doesnt work.

How can I get the slicer to manipulate the Location table please?

Thank you

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[BugmanJ]

The screen shot above is the most simplistic data going. The answer is simple, when selecting options on the slicer, only those options should be viewable

[Anonymous]

Hi @BugmanJ ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[BugmanJ]

The screen shot above is the most simplistic data going. The answer is simple, when selecting options on the slicer, only those options should be viewable