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 ...
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.

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.