Forum Discussion
Power BI error
Hi, I am not able to understand why i am getting a blank visulaziation when i select a particulare region from my dashboard, despite i have create the relationship between my tables. Please f...
yes they are not blank.
you cannot set all the relationship to cross filter, its only possible for any one of the relationship. the moment you try for any other relationship for cross filter, it won't allow you.
Regards, vinod
Got it. In that case, the only workaround I can think of is to create a big intermediary table that would merge all your "middle" tables in a single one and then apply the bi-directional filter between this new table and the two data tables in your model. Because I'm quite sure the issue here are the missing cross filters.
Regards.
Unfortunately we can't do that, because to setup a relationship, the other table must hava unique values.