Week Number Filter Shows Full Month Data Instead of Weekly Breakdown

[Lolo_2023]

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

[v-sshirivolu]

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 fields 

Week 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 4

Verify 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 table

If you’re using a slicer from a separate calendar/week table, it must be related to the main data table.

Confirm It's Working

If 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.

[v-sshirivolu]

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.

[v-sshirivolu]

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

[v-sshirivolu]

Hi @Lolo_2023 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[Cookistador · Accepted solution]

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] - 1 

Now, 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