Forum Discussion

mjohannesson's avatar
mjohannesson
Icon for Advocate I rankAdvocate I
9 years ago

Filter direction isn't valid for this relationship

I try to create a relationship two views, but Power BI Desktop complains that "The filter direction you selected isn't valid for this relationship". The "many" view has a foreign key int column which...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi mjohannesson,

 

Are you trying to set the relationship's cross filter direction to ‘Both’ when you create the relationship between the two views?

There are some situations where Power BI Desktop cannot set a relationship's cross filter direction to ‘Both’. Cross filtering both directions works well for a pattern of star schema like below.

However, cross filtering direction does not work well with a more general pattern often found in databases, like in the following diagram.

So please go and check the pattern of your table relationships and follow the article below to create and manage relationships in Power BI Desktop correctly.:smileyhappy:

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-and-manage-relationships/

 

Regards

JorgeDiego's avatar
JorgeDiego
Icon for Advocate I rankAdvocate I
9 years ago

I´m having the same problem and it doesn´t work. The columns types are exactly the same, but it is imposible to create the relation. Moreover, it let me create the relation with another columns with different types (numbers, string, dates...). 

 

I think this is an error. 

 

It would be find that Power BI shows more detail in that type of errors, because many times it´s almost immposible work with this tool.