Forum Discussion
Power BI error
you nailed it correctly below
Based on your capture, my guess is that you've had other selections made in visuals (it seems to be the case in the table in your capture), and these additional selections were not returning values for the others visuals.
I did some testing on cross filters, but thats not helping at all.
Now the question would be how those additional selections can return values for other visuals?
please suggest? Can you check with your expertise, if something works for you?
If ALL the relationships are set to "Both" in the cross filter, the filters should work the way you expect. Are you sure the blank visuals are not related to not having data?
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.