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
Thankyou for your follow-up!
It looks like you're on the right path using TREATAS(), but the blank output likely indicates that the measure isn't receiving the expected filter context.
Here are a few things to check:
Make sure the disconnected Date Table used in the TREATAS() measure is the same one connected to your slicer. If they’re not aligned, the measure won’t return any results.
If the matrix or table doesn’t include relevant fields (like category or date), the measure may return blank due to missing context. Try adding a basic column from the work order table to validate this.
Even before applying a slicer, the disconnected Date Table needs to have data in the current context. If the slicer or visual doesn’t trigger that, the measure will show null.
Happy to help! If this addressed your concern, marking it as "Accepted Solution" and giving us "kudos" would be valuable for others in the community.
Thank you.
I had overlooked the Date vs Date/Time types which caused the return of nulls. All is well now. Thanks again for your insight!