Forum Discussion
Single slicer, single data table, multiple matrix visuals not
Hi paz71,
Thanks for connecting with the Microsoft Fabric Community Forum and Thank you rajendraongole1 for your input.
Your approach using USERELATIONSHIP() is valid for handling inactive relationships. However, if adjusting the Min Date in the slicer is still causing issues, an alternative approach is to use a disconnected Date Table with TREATAS().
USERELATIONSHIP() works well when activating inactive relationships, but slicers may not always behave as expected. Using TREATAS() with a disconnected Date Table allows more control over filtering, ensuring that both Created Date and Closed Date respond correctly.
This method has been successfully used in similar scenarios, and it can help resolve the issue if USERELATIONSHIP() is not working as expected.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
Hi paz71,
Thanks for connecting with the Microsoft Fabric Community Forum and Thank you rajendraongole1 for your input.
Your approach using USERELATIONSHIP() is valid for handling inactive relationships. However, if adjusting the Min Date in the slicer is still causing issues, an alternative approach is to use a disconnected Date Table with TREATAS().
USERELATIONSHIP() works well when activating inactive relationships, but slicers may not always behave as expected. Using TREATAS() with a disconnected Date Table allows more control over filtering, ensuring that both Created Date and Closed Date respond correctly.
This method has been successfully used in similar scenarios, and it can help resolve the issue if USERELATIONSHIP() is not working as expected.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you.
Hi paz71,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi paz71,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
Hi paz71,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.