Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Niraj_vora0106
Helper III
Helper III

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. 

 

 

1 ACCEPTED SOLUTION
rbriga
Impactful Individual
Impactful Individual

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!Victory!

-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
rbriga
Impactful Individual
Impactful Individual

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!Victory!

-------------------------
Data analyst by day, hockey goalie by night.
Did I help? Then please hit that "kudos" or "accept as a solution" button!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.