Forum Discussion
Change relationship based on graph selection
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?
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,
PankajIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
7 Replies
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,
PankajIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi,
Share some data to work with and show the expected result in a table format very clearly.
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!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!
I have two tables and create bar graph and scatter plot graph . I encounter an issue where when I click somewhere in the bar chart, the scatter plot also changes, but the table I use for both the bar chart and the scatter plot is not related. Both of the tables dont have any relationship and even in the model views , it doesnt show any relationship . I have try to format the interaction but it seems like when i click the bar graph , the scatter plot still go through changes .I have two tables and create bar graph and scatter plot graph . I encounter an issue where when I click somewhere in the bar chart, the scatter plot also changes, but the table I use for both the bar chart and the scatter plot is not related. Both of the tables dont have any relationship and even in the model views , it doesnt show any relationship . I have try to format the interaction but it seems like when i click the bar graph , the scatter plot still go through changes .
