Week Filter in Power BI

[Niraj_vora0106]

Hi community,

I've a doubt regarding Weekwise Filter! 

Is it possible to use a Weekwise Filter in Power BI.?

Like we have Monthwise Filter which we use in Slicer. 

Eg: Jan,Feb,March etc etc.

Do we have any functionality for creating Weekwise Filter which we can use in Slicer? 

Eg: My current week ranges from Sunday-Saturday 

so is it possible to create weekwise filter and use in Slicer? 

Eg: 3rdJuly-9th July 2022

10th July-16th July 2022 and so on. 

[Anonymous]

HI @Niraj_vora0106,

Did you mean the split your month into different weeks? If that is the case, you can add a calculated column to calculate the 'Month week' to filter records:

MonthWeek =
MONTH ( Table[Date] ) & "-"
    & WEEKNUM ( STARTOFMONTH ( Table[Date] ), 2 ) - WEEKNUM ( Table[Date], 2 )

Regards,

Xiaoxin Sheng

[rbriga · Accepted solution]

If you have a calendar table, you may add a "week start" field and use that as a slicer, X axis, table rows and more.

Either do that at the source (such as an SQL query) or in the Query Editor:

Victory!