Date Range and Period filter

[AsNa_92]

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?

[Anonymous · Accepted solution]

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]

Thanks alot @Anonymous 

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

[rohit1991]

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.

[speedramps]

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.