How to allow user, on the HOME SCREEN, to choose the interval in order to 'filter' the records

[jr3151006]

Hi,

our project is based on 02 Excel spreeadshets (hosted on OneDrive), today we are fixing the interval to filter records based on the date, lastest quarter for example.

We would like to offer 02 fields on the home screen, where the user could set the 'Start_Date' and the 'End_Date' to filter records//results.

>>> How to accomplish that?

[amitchandak]

@jr3151006 , Check if you need

Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15

[amitchandak · Accepted solution]

@jr3151006 , You can have a common date table joining with both dates. One join will be inactive and you can activate that using userelationship

refer between date and use relationship

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Attached file have more examples