left relationship without merging

[nkasdali]

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

[anilb1603]

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

[parry2k · Accepted solution]

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