Forum Discussion

Koritala's avatar
Koritala
Icon for Post Patron rankPost Patron
10 months ago
Solved

Date Range Slicer Should Allow To Choose Date between First Of Current Month To Today's Date

Hi All, Need a help in Make Date Range Slicer should always enable the dates in the calender picker from first of current month to today's date.  Example: If today's date is 25-10-2025, date range ...
Need Help
  • MFelix's avatar
    MFelix
    10 months ago

    Hi Koritala ,

     

    Easiest way believe is to add a column on your calendar table that gives 1 for avalue before today and 0 to values after then just filter out the zero on the filter pane now depending on what your data looks like and what you want to achive you can apply this to the visual or to all the pages that way it will impact every page and every visualization:

     

     

     

     

wardy912's avatar
wardy912
Icon for Super User rankSuper User
10 months ago

Hi Koritala 

 

 Add a date table that uses todays date as the maximum

DateTable = 
VAR StartDate = DATE(2025, 1, 1)
VAR EndDate = TODAY()
RETURN
ADDCOLUMNS(
    CALENDAR(StartDate, EndDate),
    "Year", YEAR([Date]),
    "Month Number", MONTH([Date]),
    "Month Name", FORMAT([Date], "MMMM"),
    "Quarter", "Q" & FORMAT([Date], "Q"),
    "Weekday", FORMAT([Date], "dddd"),
    "Week Number", WEEKNUM([Date])
)

Then add a slicer using the date, but add a visual level filter to show 'is in this month'.

--------------------------------

I hope this helps, please give kudos and mark as solved if it does!

 

Connect with me on LinkedIn.

Subscribe to my YouTube channel for Fabric/Power Platform related content!