Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Active and Inactive Relation Filtration Context

Hi, I have following tables and their relationship.     Issue is that on PowerBI report, I am not sure how to pesent both order and CreditMemo on same page filtered by Date. Orders get filt...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 
    If you want to both filter Order and CreditMemo by field Date on a same visual, you need  to:

    1. active the relationship between the Table 'Date'  and  Table 'Order'  

    2. active the relationship between the Table 'Date'  and  Table 'CreditMemo'

    3. inactive the relationship between table Table 'Order'   and table Table 'CreditMemo'

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, Anonymous 
If you want to both filter Order and CreditMemo by field Date on a same visual, you need  to:

1. active the relationship between the Table 'Date'  and  Table 'Order'  

2. active the relationship between the Table 'Date'  and  Table 'CreditMemo'

3. inactive the relationship between table Table 'Order'   and table Table 'CreditMemo'

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.