Top N skips values

[ImPalaBI]

I have a table with sales by week. In a matrix visual, I want to see onle the last 4 weeks. So I filter the table to show only top 4 week.
Like this:

It should show weeks 42 to 45. But instead it shows 41 to 45 and skips week 44.

Any idea how I can solve this? Or even better, how can I do it in Query Editor so the data does not loads at all?
Thanks!

[v-shex-msft · Accepted solution]

HI @ImPalaBI ,

It seems like you are filtering on top 4 records based on the amount, I'd like to suggest you use topn filter with 'week number' field.
If above not help, can you please share some sample data for test?

Regards,

Xiaoxin Sheng

[nahid3152]

HI, 
Can u share ur file with us so that we identify why 44 is not visable ?