Custom Date Range Slicer Not applying on visuals

[Surekha_PM]

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 working now. This is working for a few visuals and not for a few visuals. When a user is selecting the "Current Month," the slicer is correctly filtering the current month in the calendar date. But in the visuals it is still showing the full date's data (i.e., lifetime). I am also seeing one blue i button (i.e., error), as in the image below.

I am also seeing this error. 

Any idea what all these are? And why is it happening?

Regards,
Surekha

[v-vpabbu]

Hi @Surekha_PM,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[Surekha_PM · Accepted solution]

Hi @v-vpabbu,

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

[v-vpabbu]

Hi @Surekha_PM,

As we haven't heard back from you, At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

Thank you for being part of the Microsoft Fabric Community.

Regards,

Vinay Pabbu

[Surekha_PM]

Hi @v-vpabbu,

I appreciate your reply. However, it didn't resolve the problem. I'm looking for alternative solutions to this issue.

Regards,
Surekha Prasad

[v-vpabbu]

Hi @Surekha_PM,

Could you let me know if any recent changes have been made to the report, such as updates to the visuals, filters, or the data model? Sometimes, even small changes can affect how the slicer interacts with the visuals.

Regards,

Vinay Pabbu

[v-vpabbu]

Hi @Surekha_PM,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @Surekha_PM,

Thank you for reaching out to Microsoft Fabric Community Forum.

This was due to the filter being based on a separate table that wasn't directly connected to the main data model. Because of this, filters did not consistently apply across all visuals.

To fix this, align the custom date range logic with your existing Date table — the same one that’s already connected to your report visuals. This way, whenever someone selects a time period, the filter automatically flows through the model and updates all the visuals consistently.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[Surekha_PM]

Hi @v-vpabbu 

Thank you for your response. I tried to connect the Date table with my current data date column, but still this isn't working. When I am selecting the duration, the table (specifically card visuals) is not changing, but when I am selecting the same date range manually, it is throwing the error.

Any other reason for such error? This wasn't there previously. Does incremental refresh have to do with this anyhow?

Regards, 
Surekha

[v-vpabbu]

Hi @Surekha_PM,

Please check if the incremental refresh settings align with the slicer's date range, as mismatches could occur if they are not aligned.

Regards,

Vinay Pabbu

[johnbasha33]

@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]

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