Displaying all the data in the chart when selecting calendar object

[#1]

Hi,

I have a requirement where in there are 2 calendar objects ,start date and end date.The data is stored as 1st of every month in the start date and 30/31st of every month .When i select 1st of any month in the start date i will be getting data in the straight table which displays the records but when i select 2nd or 3rd of jan then i will not be getting any data for that whole month of jan.

Is there any way to select any date in that month as start date and any month as end data,that month data should reflect in the chart?

[#2]

Thank you so much Jonathan and Jagan.I tried the below expression and its working fine now

=Sum({<[Start Date] = {">=$(=MonthStart(vminstartdate))<=$(=MonthEnd(vmaxenddate))"}>} aggr([PWR Actual Effort],[Name],Resource,[PW Fiscal Year],[Month/Year]))