Forum Discussion

winters_c's avatar
winters_c
New Member
1 year ago
Solved

Page level Filter not working

  The above page level filter is not sorting the correct results.   Please advise
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi winters_c ,

    Thank you for reaching out to the Microsoft Fabric Community. Also thank you Elena_Kalina for pointed out the common reasons this issue might happen like conflicting filters, hidden time values in the LossDate column, mismatched date formats, or filters that sit right at the edge of the date range.

     

    To address your issue in more detail, first make sure that LossDate is part of an active relationship in your data model and properly linked to the visuals you're using. Also, check if any of your measures use functions like REMOVEFILTERS or ALL() these can override the filters you've applied on the page. Please confirm that you’re using the exact same LossDate column in both your visuals and the filter pane. If time values are causing trouble, try creating a date-only version using DATEVALUE([LossDate]). As a quick test, try filtering a small date range like just one week and see if the issue still happens. These steps should help you get your filters working correctly.

     

    Hope this helps. Please reach out for further assistance.

    If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.