one slicer to filter 2 graphs

[Vindesh]

Hi,

I have 2 datasets which has (Team,RM,ASM,Activity)columns as common.

In addition to above columns, Table 1 has status cloumn and Table 2 has Listed/Not listed column.

I have joined these two tables on RM columns as many to many relationship.

I have added 3 slicers as Team,RM,ASM from Table 1.

When i use Team slicer it works perfectly for both the multi KPi cards but when i use next sliers as RM it only works for the KPI build from Table 1 and other KPI card does not gets filtered which is build from table 2.

[Ashish_Mathur]

Hi,

Ideally you should not create a Many to Many relationship.  I can help you if you share some data to work with, describe the question and show the expected result.

[Anonymous · Accepted solution]

Hi  @Vindesh ,

1. Make sure you have bidirectional cross filter turned on as it may be an issue with how the filter flows.

2. Whether the Cross filter direction in your relationship is Single, this will also cause the slicer to not work on Table2, you need to set it to Both.

This is the related document, you can view this content:

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

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

Best Regards,

Liu Yang

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