Forum Discussion
Single slicer, single data table, multiple matrix visuals not
- 1 year ago
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.
paz71 Hey,
I will suggest you to create a category column based on closed date.
you can filter the data as per your requirement.
Thanks
Harish M
Did I answer your question? Mark my post as a solution! Appreciate your Kudos