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 slicer should enble the dates in calendar oicker from 01-10-2025 to Todays  date (25-10-2025). future dates in this current months should be desable for the selection(it should be grayed out).

My expectation will be like always users should be allowed to choose the dates between first of current month to till today's date.

If anyone can help in sharing the sample pbxi file with the above logic will be helpful.

Thanks,

Sri.

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:

     

     

     

     

6 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    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!

     

  • v-aatheeque's avatar
    v-aatheeque
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi Koritala 

    Just checking in to see if the previous responses helped resolve your issue. If not, feel free to share your questions and we’ll be glad to assist.