Forum Discussion
Change relationship based on graph selection
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!
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!