Update week number automatically

[lmpb1988]

Hi

In power bi I have a data segmentation visual based on the week number, which in turn takes the week number information from a calendar table.
The filter is working correctly but I would like to know if there is a way when I open the powerbi file that the week number can be updated automatically and not manually.
For example, I can set the filter between week 1 and week 52 (last week of the year) and all the data will appear, but I would like it to calculate the current week automatically and not have it inputted automatically. manually.

For example, at this moment, when I open the file I have, the filter is from week 1 to week 21, according to the image I added, and I can only change this if I do it manually.

Thanks

[lmpb1988]

Tks, that works.

[lmpb1988]

But a measure can't be added to a field right?

[bhanu_gautam · Accepted solution]

Apply the Filter to Your Visual:

Go to the visual where you want to apply the filter.
Drag the IsCurrentWeek measure to the Filters pane.
Set the filter to show only items where IsCurrentWeek is TRUE.

[bhanu_gautam]

@lmpb1988 , For this you can create a measure first make sure you have a date table with week number

Calendar =
ADDCOLUMNS (
CALENDAR (DATE(2023, 1, 1), DATE(2023, 12, 31)),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Week Number", WEEKNUM([Date], 2) -- 2 indicates that the week starts on Monday
)

Then create a new column in this date table to calculate current week

CurrentWeek =
IF (
YEAR(TODAY()) = [Year],
WEEKNUM(TODAY(), 2),
BLANK()
)

Then create a measure for current week

CurrentWeekMeasure = WEEKNUM(TODAY(), 2)

Use this instead of Numweeked