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:

     

     

     

     

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:

 

 

 

 

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

    Hi MFelix,

    Could you please share the pbxi file. 

    I couildn't understanding the screenshots logic.

    Thanks,

    Sri.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      10 months ago

       Hi Koritala ,

       

      Please see file attach be aware that my file only have one table the calendar.

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

        Hi MFelix,

        I really appreciate your quick responses.

        I have gonr through your pbxi file. One thing I want to highlight here is that my requiurement is start date default should always should select first date of current month( Example: 01-10-2025). and End Date will always be today's date. 

        But in your file whole year dates are allowing to choose from date range that is not expected.

        Expectation is start date should always start from 1st of current month and End date should be today's date.

        Thanks,

        Sri