Query regarding Managing relationships

[PremaBoddeda]

Hi All,

I was stuck with a problem in Power BI. I have created Power BI report which has 2 pages. I have considered 2 tables which are dependent on each other and one of the table is dependent on date table. So the scenario is, for first page the tables should be in active relationship between table 1 and date table and for second page, the tables should not be in active state. I have already used userelationship method and role playing dimension. So please suggest me any other tricks or tips..

[amitchandak · Accepted solution]

@PremaBoddeda , For Date slicer sync. You can use sync slicer

To have a different relationship, you need to create inactive joins. and create measure to activate them

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[PremaBoddeda]

Thankyou @amitchandak . will be trying this method!