Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |