Forum Discussion

ctbj's avatar
ctbj
Frequent Visitor
9 years ago
Solved

Something is wrong with relationships in graphs

 

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.

 

Data Modeling
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    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

4 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    ctbj

     

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

     

     

    Best Regards,
    Herbert

    • ctbj's avatar
      ctbj
      Frequent Visitor
      9 years ago

       

      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's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        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