The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
29 | |
19 | |
13 | |
8 | |
5 |