Forum Discussion

york's avatar
york
Helper I
3 years ago

Multiple slicers connected

Hi,    I have table A, it has two columns that are named Product Type and Supplier, and I have other 2 tables, table B has a column named Product Type, Table C has a column supplier, then table A re...
Need Help
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Okay, can you try changing the cross filter direction to both on the supplier table relationship

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

york's avatar
york
Helper I
3 years ago

Hi Doleary85:

   It's genuinely nice of you! I have a table named defect table, the defect table is a reference table of inspection summary, when I choose the filter direction to both between product type and inspection summary, it worked, but when I choose the date table, the power BI remind that it doesn't work, please see the below:  

 

 

  • DOLEARY85's avatar
    DOLEARY85
    Resident Rockstar
    3 years ago

    No problem.

     

    I think maybe the next step is to create a measure for the supplier field using CROSSFILTER and change the direction of the cross filter within this rather than in the model.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

  • york's avatar
    york
    Helper I
    3 years ago

    Hi DOLEARY85:

       Sorry for my late reply, what kind of measure do I need to create?