Solved: Re: wrong data

Anonymous · ‎09-25-2020

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 · ‎09-25-2020

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

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

View solution in original post

AllisonKennedy · ‎09-25-2020

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

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com