filter record by user selection date in reporting

[space83]

Below is example of data which will display in reporting.

How can I make the data will reflect by selection of the date, pick by user in reporting?

As example user just want to see record from 1 Feb 2020 to 6 Feb 2020.

During preload, by default it will show all current record of the year 2020.

[amitchandak · Accepted solution]

@space83 , You can create a slicer on the status date and use that. Or join status date with date table and use the slicer on date table.

To deafult on this year, refer to mu video : https://www.youtube.com/watch?v=hfn05preQYA