Forum Discussion

AsNa_92's avatar
AsNa_92
Resolver 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.

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
Resolver II
1 year ago

Thanks alot Anonymous 

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