Week Number Filter Shows Full Month Data Instead of Weekly Breakdown

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.