Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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:
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
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:
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |