Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I just realized that the filters "pane" on a visual for last week, and for last month, seems to be 7 days back and 30 days back.
I need it to relative to the week and month im in, but it dosent seem to work like that.
and i hoped i didnt have to write DAX for this?
Anyone know if i do anything wrong. I mean, last week shold be an easy and most intuitive "last week" and not previusly 7 days..
Also i dont see the diffrence between inte last week, or in the last calender week.
No one?
So no one?
This is the case then, a week cant start on a monday in a simple filter, it has to be a DAX thing?
Seeems to be an issue? but there must be a way and not having to create dax mesures?
https://community.powerbi.com/t5/Desktop/Page-Filter-Relative-date-filtering-week-start-day/m-p/9212...
Do i really have to do this insain workaround just to start a week slicer from monday?
https://radacad.com/week-to-date-calculation-in-power-bi-with-dax
Humm, i have about 2-3 months of data, with dates on "every data point"
I have solved previus month, that seems to be fine with filtering " calendar month" instead of "month"
but if i want to only show last week (mon to sunday) it shows sund-saturday. with the filter "calendar week" on a filter.
maybe a setting in the settings for the application, i will have a look."
I found regional settings, but is says:
"Language used when comparing strings in data for creating internal date fields. this only applies when a report is first created, and cant be changed on existing reports"
So i guess its not there.
But on "current file" in settings there something similar.
Regional settings, but that one is set to my contry, and says it
intepret nubers dates and times in imported text, but i dont think its that setting either.
Humm it seems to work with calendar month, but week is starting on a sunday?
Any way of making it mon-sun instead?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |