Something is wrong with relationships in graphs

[ctbj]

Hey.

What is wrong? I don't understand why I get two different graphs? They must be the same, because the variables, MELDING_ID and TOGMELDING_ID, are related.

[ctbj]

@v-haibl-msft

Aha okay. It works perfectly now.

Thank you 🙂

[v-haibl-msft]

@ctbj

You need to change the cross filter direction from Single to Both.

Best Regards,
Herbert

[ctbj]

@v-haibl-msft

How do you that? Power BI will not let me change the cross filter direction from Single to Both.

The field in the cross filter direction is grey, ie. it is impossible for me to change the direction. It is locked.

Is it because I'm using Direct Query? or....? Why the field is locked?

[v-haibl-msft · Accepted solution]

@ctbj

To enable cross-filtering for DirectQuery in Power BI Desktop, select File > Options and settings > Options, then check the box next to Enable cross filtering in both directions for DirectQuery.

Best Regards,
Herbert