Forum Discussion

Surekha_PM's avatar
Surekha_PM
Resolver 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
Super 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 !!





  • Surekha_PM's avatar
    Surekha_PM
    Resolver I
    1 year ago

    Hi johnbasha33 

    Thank you for your response. I couldn't understand how to make the above changes. I am using below formula to filter out the date
    ----------------------------------------------------------------------------------

    Duration =
    var _today = Today()
    VAR CurrentMonth = EOMONTH(TODAY(), -1)+1
    VAR MonthEnd = EOMONTH(TODAY(), -1)
    VAR MonthStart = EOMONTH(TODAY(), -2) +1
    VAR MonthEndThree = EOMONTH(TODAY(), -1)
    VAR MonthStartThree = EOMONTH(TODAY(), -5) +1


    RETURN
    UNION(
        ADDCOLUMNS(
            CALENDAR(CurrentMonth,_today)
            ,"Filter", "Current Month",
            "Order", 0
        )
        ,ADDCOLUMNS(
            CALENDAR(MonthStart,MonthEnd)
            ,"Filter", "Last Month",
            "Order", 0
        )
        ,ADDCOLUMNS(
            CALENDAR(_today - 90, _today)
            ,"Filter", "Last 3 Months",
            "Order", 1
        )
        ,ADDCOLUMNS(
            CALENDAR(_today - 180, _today)
            ,"Filter", "Last 6 Months",
            "Order", 2
        )
        ,ADDCOLUMNS(
            CALENDAR(_today - 270, _today)
            ,"Filter", "Last 9 Months",
            "Order", 3
        )
        ,ADDCOLUMNS(
            PREVIOUSYEAR(DATESYTD('Date'[Date]))
            ,"Filter", "Last Year",
            "Order", 4
        )
        ,ADDCOLUMNS(
            CALENDAR(MIN('Date'[Date]),MAX('Date'[Date]))
            ,"Filter", "Custom",
            "Order", 5
        )
    )

    -------------------------------------------------------------------------------------------------
    And this is the Date filter I have calculated
    ---------------------------------------------------------------------------------

    Date =

    ADDCOLUMNS(CALENDAR(01-01-2023,TODAY()),
            "Year", Year([Date]),
            "Quarter", "Q" & QUARTER([Date]),
            "Month Number", MONTH([Date]),
            "Month", FORMAT([Date],"mmmm"),
            "Week Day Number", WEEKDAY([Date],2),
            "Week", FORMAT([Date],"dddd"),
            "Day", DAY([Date])
    )
    -----------------------------------------------------------------------------------

    Now when I am selecting the current month, the second date filter is working fine, but it is not reflecting in the graph. The graph has data from another table, which is coming from data. 

    If this sounds confusing, then let me know; I can explain further.

    Regards,
    Surekha