Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
7 years ago
Solved

left relationship without merging

Hello,
I have a question about the relationships between the tables in PBI.
Example:
Sales table: with year field (2017 & 2018)
Calendar table: with the year field (2010 to 2018)

Both tables have a relationship on the date field,
In my example, a YEAR slicer from Calender shows values from 2010 to 2018.

I'm used to Qlik, we can define a relationship with a LEFT KEEP (it recover from the right that correspond to the left).

So how can I make my "Calendar" table only show the data equal to my Sales table. Is there a way to do the same thing with PBI? without using the merge function please

 

Regards

Need Help
Tips and Tricks

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    nkasdali try cross filter direction to both where you setup the relationship.

  • anilb1603's avatar
    anilb1603
    New Member
    3 years ago

    Hi,
    I have a similar requirement where I have 5 different tables in a model and I need to apply a filter to all the tables without using a merge. In qlik, we can simply use Left Keep which would take care of filtering. Looking for the same option in Power BI. Basically, my PBI model (tables) is connected through Order#. I need to apply the filter Order status = 'Active' in the first table which would give the active order#'s and then keep the same acive order#'s in all other tables in the model. I looked at some list filter options but not sure that's an efficient way to do this.

     

    Any help would be appreciated.

     

    Thanks