Forum Discussion

Aliceeee's avatar
Aliceeee
New Member
7 months ago
Solved

Matrix filter not working when using a single direction relationship

Hi, I have a Matrix which displays data from "Availability Sheet", however I want to filter (via slicer) based on values from another table. So since these 2 tables have repeating 'Full Name' values,...
Need Help
  • rohit1991's avatar
    rohit1991
    7 months ago

    Hii Aliceeee 

     

    With single-direction relationships, filter flow only travels from the lookup (dimension) table to the fact tables, not between fact tables. In your model, the slicer is coming from the Advanced table, so its filter cannot propagate through the FullNames lookup to the Availability Sheet. When you switch to bidirectional, Power BI allows that fact-to-fact filter flow, which is why it works. To keep single direction (best practice), create the slicer from the FullNames lookup table or use a measure with TREATAS() to explicitly pass the filter from Advanced to Availability.

v-priyankata's avatar
v-priyankata
Community Support
7 months ago

Hi Aliceeeee 
you can get the option like below , so you can accepte the users response as a solution. If you don’t see it, please try opening it in another browser or in a new window.

 

v-priyankata's avatar
v-priyankata
Community Support
7 months ago

Hi Aliceeeee 
Are you able to see the option? if not, please follow the steps. 
please try opening it in another browser or in a new window.