Forum Discussion

Surekha_PM's avatar
Surekha_PM
Icon for Resolver I rankResolver I
1 year ago
Solved

Custom Date Range Slicer Not applying on visuals

Hello, I have a custom date range calculated in my dashboard. Which is interacting with the date filter (Calendar Date) as shown below. It was working properly earlier, but it is not workin...
Need Help
  • Surekha_PM's avatar
    Surekha_PM
    1 year ago

    Hi Anonymous,

    The issue is not resolved. I am trying to find the solution. Once I find sometihng I will share it for everyone's reference.

    Regards,
    Surekha Prasad

johnbasha33's avatar
johnbasha33
Icon for Super User rankSuper User
1 year ago

Surekha_PM 

Custom Date Range Logic Conflict

If your custom date range logic (e.g., “Current Month”) is a calculated column or measure, it may not be responding to slicer selections the way you expect.
IsCurrentMonth =
IF(MONTH([Date]) = MONTH(TODAY()) && YEAR([Date]) = YEAR(TODAY()), 1, 0)

🛠 What You Can Try Right Away

  1. Verify relationships: Ensure Calendar Date is correctly related to your fact table.

  2. Inspect visuals with errors:

    • Check which field is used for filtering

    • See if it uses a different date column or disconnected table

  3. Test filters:

    • Temporarily replace the "Current Month" slicer with a direct filter on Calendar Date and see if it works

  4. Check the error message on the “i” icon and share it here if unsure — that’ll help pinpoint it fast

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!