Forum Discussion
Pikachu-Power
Impactful Individual
Impactful Individuallast 8 week in filter is wrong
hi all, i have a question concerning a filter in power bi desktop in the new filter pane. when i use relative date and say show me the last 8 week it gives me 02.02.2020-28.03.2020. but that is wro...
amitchandak
Super User
Super UserThere is idea going on this : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37979920-by-default-the-relative-date-slicer-set-sunday-as
Refer if this file can help you: https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0
Pikachu-PowerImpactful Individual
Impactful Individualare there some workarounds then?
astojanacHelper II
Hello Pikachu-Power ,
My suggestion for you is to create calendar table with column 'Week Number' and then to use 'Week Number' in slicer and on that way select as many weeks you need.Dax for coulumn: Week Number = WEEKNUM(Calendar[Date], 2)Numer 2 in dax means that week starts on Monday.
Best regards,
Alex