Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Filter in Visuel takes the wrong dates compare to my datetable

Hi,

 

I have some problems when I use filter in visuel. I will like to show the data from Last Week (week 19), but the date it shows is wrong "In europe the week starts on a monday. I have created a calender where is shows the dates right - But when I use the fuilter in visuel it takes data from 9th-15th, but I want it to take the data from 10th-16th.

 

 

 

AnnJ2209_0-1621519970463.png

In order intake per week - salesman it takes the right dates(week) - but over in the order intake where have have filter ralativ date it takes the 9th-15th.. Is there any why where i can use the visueal filter on relativ date, last week to take 10th-16th ?

AnnJ2209_1-1621520152485.png

 

 

 

 

 

1 REPLY 1
HashamNiaz
Solution Sage
Solution Sage

Hi @Anonymous !

You can set the week start date using DAX as showin in below article;

 

Calculating Week Start Date with DAX in Power BI 

You can define the week starting day using this logic.

 

Regards,

Hasham

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.