Change relationship based on graph selection

[ElvirBotic]

Hello, 

I am wondering if there i s a proper way to handle multiple relationships when a user selects a bar graph value to filter a table based off of that new relationship. Currently I have a date dim related to my fact using a forecast date as the active relationship. I have another relationship for actual date. I have two bar grpahs for testing one plotting expected closuers by month using the forecast date and another graph to show closure by month using the actual date. How would i be able to let the user select for example Jan 2025 and see the ones that were actually closed and not which are forecasted to be closed?  

Is it possible or would I need two seperate pages? Or should I just use the actual date as my active relationship? 

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result in a table format very clearly.

[v-aatheeque]

Hi @ElvirBotic 

If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @ElvirBotic ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @ElvirBotic ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[pankajnamekar25 · Accepted solution]

Hello @ElvirBotic 

You can achieve this using USERELATIONSHIP in a measure instead of changing the active relationship.

ActualClosures =
CALCULATE(
COUNT(FactTable[ID]),
USERELATIONSHIP(DateDim[Date], FactTable[ActualDate])
)

Use this measure in your table visualization.

When a user selects a bar from the Actual Closures graph, it will filter based on Actual Date.

No need for separate pages

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.