wrong data

[Anonymous]

hiii

i have a slicer with week nos in it and my charts will change as per the slicer selection

now we are in week 39 it should show the data till week 39

but unfortunately the slicer is showing till 53 weeks after 39 also it is showing the data which is wrong.

can some help to rectify it.

https://drive.google.com/file/d/1ySauhYpsWJ7BfmbOxOzqTJ727v7y6bQp/view?usp=sharing

[AllisonKennedy · Accepted solution]

Hi @Anonymous 

This is because you have data back to 2017. I have added a slicer for year to your page, and it now only shows week num to 39 and that should fix your numbers too. See attached file please below signature.

I do recommend trying a more robust Date table than the one you have created using DAX, but up to you. https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html