Slicer not filtering correctly in Power BI

[SA9]

Hi everyone,

I’m stuck with a problem in Power BI and haven’t found a solution yet. I have a slicer for week numbers (Week 1, Week 2, Week 3, etc.), and I want it to filter my visualizations properly.

The issue is:

• When I add the slicer to the report, it does not filter the visuals, even though the field for Week exists in the same table as my fact data.

• The slicer changes, but nothing happens in the visual.

• I already tried connecting relationships and checking the fields, but still no filtering.

• All data in the dashboard from one table ( JUNE )

What I need:

• I want the slicer to act as a filter for my visuals based on the selected week.

[SA9]

it is fixed. 

thanks all for your suppourt and help. 

[MasonMA]

Has the issue been fixed? Please post your solution and mark it as well so that other users can benefit if they are looking for answers with similar issues:) 

thanks. 

[Shahid12523]

Use the Same Field
– Make sure your slicer and visuals both use the same Week column from the JUNE table.

Check Data Type
– Ensure Week is the same type (e.g., text like "Wk 01" or number like 1) in slicer and visuals.

Edit Interactions
– Go to Format > Edit Interactions, click the slicer, and set all visuals to filter.

Remove Visual-Level Filters
– Check visuals for any filters blocking the slicer.

Check DAX Measures
– Avoid using ALL(JUNE[Week]) in your DAX. It ignores slicers.

[SA9]

your suppourt is needed.

i tried everything but im still facing issue please suppourt. 

[V-yubandi-msft]

Hi @SA9 ,

Thank you for raising this, and thanks as well to the @Abhilash_P and @jaineshp  for their thorough responses. They’ve already mentioned important checks like field consistency, data types, interactions, and cleaning values.

Please review those suggestions. If you still encounter any issues or need more information, feel free to let us know and we’ll be glad to assist further.

Thanks for your responses @Abhilash_P , @jaineshp .

Regards,
Yugandhar

[SA9]

Thanks to all @jaineshp @Abhilash_P  but still the issue not yet solve/. 

[MasonMA · Accepted solution]

Hello @SA9 

Your 'WK' looks just a label, it cannot filter correctly unless there’s a proper relationship between DATE field and WK.

As I see when the slicer on WK is renamed to values (22, 23…), since those 22/23 labels exist for every Day, filtering doesn’t reduce the Day values on your bottom chart 'Availability by Week and Day' properly. So slicer seems to do nothing. 

I'd suggest you build a correct Date table and have it filter your 'JUNE', 'MAY' tables. A 'Calendar' table can be built via DAX like (Adjust below Start and End date based on your situation)

Calendar =
ADDCOLUMNS (
CALENDAR (MIN(JUNE[Date]), MAX(JUNE[Date])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Day", DAY([Date]),
"Week", WEEKNUM([Date], 2) 
)

And then relate Calendar[Date] to MAY[Date], JUNE[Date] and so on if there are more later on, use Calendar[Week] in slicers and on the chart, instead of JUNE[WK].

This way, Day and Week are consistently tied to the same Date dimension.

Hope this helps:) 

[Abhilash_P]

Hi @SA9 ,

If your week number slicer isn’t filtering your visuals even though the week field is in the same table here are some things to check:

• Make sure the visuals are using the same table and the same Week column as the slicer. Sometimes if visuals are built from different tables or calculations, the slicer won’t work.

• Check that the Week field’s data type is the same everywhere. For example, if the slicer uses text like “Week 1” but your visuals use numbers like 1, the filtering won’t happen.

• Look at your visuals to see if there are other filters set that might block the slicer from working properly.

• Try selecting the slicer, then go to "Edit Interactions" in the ribbon, and make sure the slicer is set to filter your visuals (you should see a funnel icon).

• If nothing helps, try removing the slicer and adding it again. Sometimes Power BI gets stuck and this resets things.

Your slicer and visuals have to talk to each other using the exact same Week field. If they don’t, the slicer won’t filter the data.

If you want, create a simple table visual showing weeks and sales, then apply the slicer to test if it filters properly. That can help pinpoint where the problem is.

[SA9]

Thanks but nothing work. 

i changed the names from WK22 to 22, but still not filtering. 

Please guide me.