Forum Discussion
Slicer issue
Hi all,
I have two tables table1 and table2 .
Table1 is having fields namely MCC , DA, and other columns. And table2 is only having fields named MCC, DA.
And i created relationship between these two tables by using MCC fields. And after that in powr bi report which I created from table1 I tried using DA field as a slicer from table2. But if we select any field from Slicers, report is not interactive. Showing static value only. If I use DA field from table1, report is interactive. Working as expected. But need to use DA field from table2 only. Can anyone help me fix this.
Hi Maha16 ,
Ensure that the relationship between Table 1 and Table 2 is set to “Both” in the Cross Filter Direction. This will enable mutual filtering between the two tables. Also, make sure that the relationship between the MCC fields in both tables is active.
Also, you need to verify that the slicer interaction settings are configured correctly. Go to the Format pane, select Edit Interaction and make sure that the slicer is set to filter the desired visual effects.
You can refer to the attached simple example that may be able to help you.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi What's cross-filter direction set under the relationship?
Maha16 , make the relationship BI Directional
Hi,
Assuming none of the 2 tables is a Dim table (or atleast you do not specify so), you need to create 2 Dim tables - one each for MCC and DA. Create a relationship (Many to One and Single) from the 2 Fact tables to the 2 Dim tables. To all your visuals, drag MCC and DA from the Dim tables.
Hope this helps.
Hi Maha16 ,
Ensure that the relationship between Table 1 and Table 2 is set to “Both” in the Cross Filter Direction. This will enable mutual filtering between the two tables. Also, make sure that the relationship between the MCC fields in both tables is active.
Also, you need to verify that the slicer interaction settings are configured correctly. Go to the Format pane, select Edit Interaction and make sure that the slicer is set to filter the desired visual effects.
You can refer to the attached simple example that may be able to help you.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
