Forum Discussion

troyh68's avatar
troyh68
Frequent Visitor
6 years ago
Solved

Trying to pull Sales Data from Dynamics NAV with multiple relationships and some filtering

To start I am VERY new to Power Bi. Learning as I go and I think I may have bit off more than I can chew. As you all know Sales Reports are always very complicated and this one is no exception. In NA...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    troyh68 ,

     

    Generally, you may make relationship below inactive to disable the filter from Sales invoice Header to Sales invoice line.

     

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • troyh68's avatar
    troyh68
    6 years ago

    v-yuta-msft 

    Thank you for the suggestion however I am still unable to get the visual to show correctly. I am re-thinking the structure and maybe starting all over again.

     

    Thank you again for your suggestion.

    Troy

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

troyh68 ,

 

Generally, you may make relationship below inactive to disable the filter from Sales invoice Header to Sales invoice line.

 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • troyh68's avatar
    troyh68
    Frequent Visitor
    6 years ago

    v-yuta-msft 

    Thank you for the suggestion however I am still unable to get the visual to show correctly. I am re-thinking the structure and maybe starting all over again.

     

    Thank you again for your suggestion.

    Troy