Coparison Page

You need to use separate relationships and visual interactions to isolate the filtering between the two tables.

Steps

1. Set Up the Data Model

Ensure Table 1 and Table 2 are both present in your Power BI model.

These two tables should ideally have identical structures since one is a copy of the other.

2. Disable Relationships Between Tables

If there are any existing relationships between Table 1 and Table 2, remove them. This ensures the two tables operate independently.

3. Create Separate Dimensions (If Required)

If you have shared dimension tables (like a date table), duplicate them as well (e.g., DateTable1 and DateTable2).

Link DateTable1 to Table 1 and DateTable2 to Table 2 in the model.

4. Build the Visuals

Add visuals for Scheme 1 based on Table 1.

Add visuals for Scheme 2 based on Table 2.

5. Add Slicers

Create slicers for Table 1 fields and place them near Scheme 1 visuals.

Create slicers for Table 2 fields and place them near Scheme 2 visuals.

6. Customize Visual Interactions

Go to Format > Edit Interactions.

For Scheme 1 visuals, ensure that only slicers connected to Table 1 affect them.

For Scheme 2 visuals, ensure that only slicers connected to Table 2 affect them.

Select the slicer and click the "None" icon for visuals it shouldn't interact with.

Thanks for the reply from anmolmalviya05.

Hi Rally00 ,

Edit interactions are available for visual. You can make changes to the way the visuals interacts by selecting format->Edit interactions.

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

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.