Show 'Different Records' or 'Common records' using a slicer

[Anonymous]

I've made a sample dataset for this situation I am facing right now.

Infotable1

Infotable2

Venue1

Venue2

Given all those tables I currently have these visuals in order to compare the tables

It can be seen in the visuals that there is clearly a difference between the data source records. I can easily use a measure and the filter pane to make it so that the visuals will only show the records that are different. But what I want to do is to use a slicer in order to achieve the same thing. Like the slicer will have the options of "Show different records" or "Show common records" and choosing one of those will show in the visuals the respective records. How do I achieve that?

Thank you in advance!

[vanessafvg · Accepted solution]

you should only use one venue table, that is what brings the data together, .  see attached.

[vanessafvg]

you need to create a table in the middle of the 2 info tables so for the venue code, create 1  separate table for venue code, create a table that has only unique records of all venue codse, and then link both of your  infor tables to the venue code in a relationship, in a single direction, one to many relationship from the transactional tables if that makes sense

then in your visuals use the venue information from  the middle table, and place your  measures on one visual.  

If you share data in text format it is easier to demonstrate, sharing in pics means you cant copy the data to create an example pbix.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

[Anonymous]

I actually have the middle table already, I should have included it in my post, my bad. I understood the part where you said to put the measure on the visual, but then again how can I include a slicer to do the filtering for me?

Anyway this is the sample pbix file I have created