Forum Discussion

paz71's avatar
paz71
New Member
1 year ago
Solved

Single slicer, single data table, multiple matrix visuals not

I have a single data table for work orders. Each record has a created date and a closed date. I'm trying to create a dashboard with 3 visualizations (2 matrix, 1 table) that can be filtered by year/m...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    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.

     

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi paz71  - Since you have an inactive relationship between the Date table and the Closed Date, can you use the USERELATIONSHIP() approach still causes issues, consider creating a disconnected date table and using measures with TREATAS().

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Using USERELATIONSHIP in DAX - SQLBI

Power BI DAX Tutorial: The USERELATIONSHIP Function (2022 - February)

 

Hope this helps.

if you can share data, that helps us from our end to check the same if still issue exist.