use 2 slicers and show the differences and equals of the two results

[Ingrid_nl]

I have a table with a colomn 'occupations' and their 'skills'. I made a copy of this table. Now i would like in the report put in 2 slicers. the user of the report kan use slicer 1 to look for occupation 1 and use slicer 2 to select occupation 2. In one table i would like to return the skills from the first occupation and mark those skills from occupation in slicer 2. In the other table i would like to returm the skills they differ. That are the skills from occupation 2 who are not present in occupation 1. I am really stuck with this. Who can help me?

[Anonymous]

Hi @Ingrid_nl 

You can use Edit interactions to realize your needs . This feature helps you filter out visuals you don't want to filter .

Change how visuals interact in a report - Power BI | Microsoft Learn 

Power BI - Edit Interactions features - Power BI Docs 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ingrid_nl]

@Anonymous Thank you very much for this tip, it helped me for the first part.

But i would like to see the difference between the second selection and the first. 

I would like to see those skills of the second table which are not present at the first table in an other table.

I think we also can solve it with conditional formating. But it should chance with changing the filter.

So the text in the first table should be green if it also appears in table 2 and the text in table 2 should be red if its not appear in tabel 1.