Facing issue in selecting the week filter

[Divyasree]

Hi all,
In one of my report ,i have to select the week range which is showing as  the slider with the selected year. according to that we have to show the total task count .

Eg: selected the week in the range of the 8th week to 13th week  with year as 2023, next in the table view we used see the respected data related to that week, but here what is happening means 7th week data also included.  actually it shouldnot happen this.

In dataset also when we apply this same filter the task count is showing as 86, but when we checked in the database it is showing as the 90 count, how we can resolve this.
This is what the filter we are trying to do. here the week numbers are converted from one of the date column to week number.
How i converted that week format is, selected on specific date column and rightclick on it-->transform---->selected on week--->week of the year.

here 13/02/2023 is included.

Need help, still not able to find the way.

[v-xuxinyi-msft]

Hi @Divyasree 

After my testing, I have not encountered the same situation as you, in order to better help you, I have a couple of questions to check with you, have you performed any other actions? What is the data type of your date column? Do you have other tables associated with this table?

Could you please provide the PBIX file? That would be very helpful. Please remove any sensitive data in advance and please do not log into your account.

Here's my testing process:

My date range is 01/01/2023-29/04/2023

I copied a date column.

Result:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.