PowerBI does not include last day of the week, possible error ?

[bilingual]

Hi, i am doing a report with data from Excel.

The problem i see is that i have a report with number of trips, which despite i use ISO-Week,  does not include sunday, when i run it today.

For example, week 5/2022 consists of only 6 days, not the 06-02-2022.

The data for 06-02-2022 is avaliable, and when i create a new slide the 06-02-2022 is included in Week 5.

I have checked all filters, and copied the matrix table 1:1 in a new slide, and there again, in the new report, the 06-02-2022 is not missing.

Last week i had the same problem with Week 4 with missing last day of week, but now Week 4 is correct, and Week 5 is the problem....

What could be the problem, if it is not the filter?

W

[amitchandak]

@bilingual , How you have created ISO week ?

like ?

weeknum([date],21)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[bilingual · Accepted solution]

Hi Amit, i finally found it, there was a hidden slicer with the last 52 weeks activated, these weeks are not ISO compatible.