Forum Discussion

AsNa_92's avatar
AsNa_92
Icon for Resolver II rankResolver II
1 year ago
Solved

Date Range and Period filter

Hi team,

 

I have a request to develop a dashboard where I should have a range date (from to) and a checkbox that should show all the data in all dates as below:

 

my data is separet dates as below:

6/11/2024 0:00
6/12/2024 0:00
6/13/2024 0:00
6/14/2024 0:00
6/19/2024 0:00
6/20/2024 0:00
6/21/2024 0:00
6/24/2024 0:00
6/25/2024 0:00
6/26/2024 0:00
6/27/2024 0:00
6/28/2024 0:00
7/1/2024 0:00
7/2/2024 0:00
7/3/2024 0:00
7/4/2024 0:00
7/5/2024 0:00
7/7/2024 0:00
7/8/2024 0:00
7/9/2024 0:00
7/10/2024 0:00
7/11/2024 0:00
7/12/2024 0:00

 

 

How can I show only one checkbox for all dates?

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from speedramps and rohit1991, please allow me to provide another insight.
    Hi AsNa_92 ,

    Please refer to the following steps.

     

    Creates a new calculated column in the calendar table.

    Column = "All Dates"

     

     Create slicers using these two columns separately. Then synchronize the filtering changes from the Calculated column slicer to the Date column slicer.


    In this way, when you select the “All Date” option of the calculated column slicer, all dates will be displayed.


    please see the attached pbix for reference.

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • speedramps's avatar
    speedramps
    Icon for Super User rankSuper User
    1 year ago

    In Power Query transform your date/time column to a date.
    In your report add a Slicer visual.

    Add the Date field to your Slicer with the Between option.
    Move the slider to select a date range.

    Then hover on the slicer and click on the erasure icon which will clear the slection.

    Teach your users and developers how to use this in-bult ALL feature, rather than developing a bespoke soution.

    Then all slicers look and behave and behave the same way, which is the UX/UI best pratice.

     

    Please click [accept solution] and thumbs up to show your appreciation, thank you.

     

     

     

     

     

  • rohit1991's avatar
    rohit1991
    Icon for Super User rankSuper User
    1 year ago

    To create a dashboard with a date range filter and an "All Dates" checkbox:

    1. Add "From" and "To" date pickers for users to filter specific periods.
    2.  Configure it to bypass the date range filter when selected, showing all data.
    3. Ensure dates are formatted consistently.
    4. Implementation:
      • In Power BI: Use a slicer for the date range and a parameter or DAX measure for the "All Dates" functionality.
      • In Tableau: Use a parameter for the checkbox and calculated fields to control the date filtering.
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from speedramps and rohit1991, please allow me to provide another insight.
    Hi AsNa_92 ,

    Please refer to the following steps.

     

    Creates a new calculated column in the calendar table.

    Column = "All Dates"

     

     Create slicers using these two columns separately. Then synchronize the filtering changes from the Calculated column slicer to the Date column slicer.


    In this way, when you select the “All Date” option of the calculated column slicer, all dates will be displayed.


    please see the attached pbix for reference.

    Best Regards,
    Dengliang Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • AsNa_92's avatar
      AsNa_92
      Icon for Resolver II rankResolver II
      1 year ago

      Thanks alot Anonymous 

      I know this way but because of the work load I forgot about it 🙂