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.

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.