Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Icon for Helper III rankHelper III
4 years ago
Solved

Week Filter in Power BI

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...
Need Help
  • rbriga's avatar
    rbriga
    4 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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