Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
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 ?
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
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 17 | |
| 10 | |
| 7 | |
| 6 |