Forum Discussion

Maha16's avatar
Maha16
Frequent Visitor
1 year ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.