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.

 

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. 

 

 

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!

2 Replies

  • rbriga's avatar
    rbriga
    Icon for Impactful Individual rankImpactful Individual
    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