Forum Discussion
Week Number Filter Shows Full Month Data Instead of Weekly Breakdown
Hi experts,
I need some help with a Power BI report.
I have an Excel file that includes the following columns:
Department
Patient Visits
No Show
Month
Week Number
My goal is to display the data per week number within each month, for each department.
The problem:
When I select the first Week (for example, Week 22, first week of July), the visuals display the entire month’s datainstead of just Week 22. The other weeks (Week 23, Week 24, etc.) show no data at all when selected.
What I need:
I want to correctly filter and present the data by Week Number so that each week only shows its respective data — not the full month.
Month | Week Number | Department | Patient Seen | No Show |
July 2025 | 1 | Cardiology | 45 | 5 |
July 2025 | 1 | Dermatology | 38 | 2 |
July 2025 | 1 | Pediatrics | 52 | 4 |
July 2025 | 1 | Orthopedics | 44 | 6 |
July 2025 | 1 | General Surgery | 40 | 3 |
July 2025 | 1 | ENT | 36 | 2 |
July 2025 | 2 | Cardiology | 50 | 4 |
July 2025 | 2 | Dermatology | 42 | 1 |
July 2025 | 2 | Pediatrics | 60 | 5 |
July 2025 | 2 | Orthopedics | 47 | 7 |
July 2025 | 2 | General Surgery | 43 | 4 |
July 2025 | 2 | ENT | 39 | 3 |
July 2025 | 3 | Cardiology | 48 | 6 |
July 2025 | 3 | Dermatology | 41 | 2 |
July 2025 | 3 | Pediatrics | 55 | 3 |
July 2025 | 3 | Orthopedics | 49 | 5 |
July 2025 | 3 | General Surgery | 46 | 2 |
July 2025 | 3 | ENT | 38 | 1 |
July 2025 | 4 | Cardiology | 53 | 5 |
July 2025 | 4 | Dermatology | 44 | 3 |
July 2025 | 4 | Pediatrics | 58 | 4 |
July 2025 | 4 | Orthopedics | 50 | 6 |
July 2025 | 4 | General Surgery | 47 | 2 |
July 2025 | 4 | ENT | 40 | 1 |
|
|
|
|
|
Hi Lolo_2023
First, add a colum to retrieve the weeknum of the first day of your month and then add the week number -1
You can convert your month column into date or create a new column and convert it into date, then use the following calculated column:
WeekNumber = WEEKNUM(RawData[Month]) + RawData[Week Number] - 1Now, you can use your weekNumber as a slicler
Ps: I joint a pbi files with the sample your shared with us
Do not hesistate if you need more support
5 Replies
Hi Lolo_2023
First, add a colum to retrieve the weeknum of the first day of your month and then add the week number -1
You can convert your month column into date or create a new column and convert it into date, then use the following calculated column:
WeekNumber = WEEKNUM(RawData[Month]) + RawData[Week Number] - 1Now, you can use your weekNumber as a slicler
Ps: I joint a pbi files with the sample your shared with us
Do not hesistate if you need more support
Hi Lolo_2023 ,
Thank you for reaching out to the microsoft Fabric community.
Try these below steps -
Check Data Types
In Data View, make sure the Week Number field is formatted consistently. If it’s a combined number like 20251, set it as Text. If it’s just the week (e.g., 51), change it to Whole Number.This helps prevent issues where slicers and visuals don’t sync correctly.
Build a Simple Table Visual
Include these fieldsWeek Number
Department
Patient Seen (Sum)
No Show (Sum)
Now, you should see all week-level rows from your data.
Add a Slicer for Week Filtering
Add a Slicer visual.
Drag in the Week Number field from the same table as your visual.
Optionally, set the slicer style to Dropdown.
Select a week (e.g., 20252) — the table should display only that week’s rows.
The reason your Week Numbers are showing as 5-digit numbers like 20251 , 20252 etc... is because they are combined values of Year and Week Number.
20251 = Year 2025, Week 1
20252 = Year 2025, Week 2
...
20254 = Year 2025, Week 4Verify Visual Interactions
Click the slicer on your canvas.
Go to the Format tab > Click Edit interactions.
Make sure all visuals (e.g., your table) show the filter icon (not the "no filter" circle).
Confirm Relationships - Only if slicer is from a different tableIf you’re using a slicer from a separate calendar/week table, it must be related to the main data table.
Confirm It's WorkingIf the table now displays only 3 rows for 20252 (one for each department), the slicer is working as expected.
Choosing other weeks should update the data accordingly.
This shows the issue was related to the field setup or data format, and it has now been resolved.
Please find the below attached .pbix file for your reference.
Regards,
Sreeteja.Hi Lolo_2023 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Hi Lolo_2023 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
