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

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

Custom Date Range Slicer Not applying on visuals

11 Replies

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

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

Inspect visuals with errors:

Check which field is used for filtering

See if it uses a different date column or disconnected table

Test filters:

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

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
  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
Anonymous
Not applicable
1 year ago
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
  Resolver I
  1 year ago
  Hi Anonymous
  
  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
  - Anonymous
    Not applicable
    1 year ago
    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
Anonymous
Not applicable
1 year ago
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
- Anonymous
  Not applicable
  1 year ago
  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
- Surekha_PM
  Resolver I
  1 year ago
  Hi Anonymous,
  
  I appreciate your reply. However, it didn't resolve the problem. I'm looking for alternative solutions to this issue.
  
  Regards,
  Surekha Prasad
  - Anonymous
    Not applicable
    1 year ago
    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
- Surekha_PM
  Resolver I
  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
  - Anonymous
    Not applicable
    1 year ago
    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

Forum Discussion

Custom Date Range Slicer Not applying on visuals

11 Replies

Custom Date Range Logic Conflict

🛠 What You Can Try Right Away

Related content

Custom Visual

Custom Matrix Visual

custom visual development

LLM Chatbot custom visual

how do I apply my custom sort to my visualization