Forum Discussion
Coparison Page
Hello everyone, thank you for the time you will give me by reading this request of mine.
I should build a report as shown in the image on a single page.
Both schemes (scheme 1 and scheme 2) refer to two data tables, one copy of the other (called table 1 and table 2)
The problem is that I have to make sure that scheme 1 can be filtered only by the fields of table 1 and scheme 2 by only the fields of table 2
I hope I have explained myself
Thanks so much for your help
Dom
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,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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 so much for the reply. But does the interaction editor also work with "Board" type objects? because I don't see a symbol to exclude
Dom
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,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
