Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

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

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?

Community Support
Community Support

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.

@Ailsa-msft 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. 




Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors