Forum Discussion
Slicers Not Working Correctly
I have a simple model. Sales and calendar tables. The calendar table was created using calendar auto and marked as the date table. Whenver I select a specific row in the table for the year 2021, the ...
amitchandak
Super User
Super UserAnonymous , Sometimes table to slicer interaction are not on. Check that.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Also do not prefer bi-directional join. You can take a measure from fact and add a visual level filter in the week slicer for that measure is not null.
refer this example for the way, work for one slicer too -https://www.youtube.com/watch?v=cyOquvfhzNM
These changes make no difference.
That video seems to be showing somethig that has been a default behaviour, when you select the year, you should only be able to select week 5 because no other weeks exist from a data perspective.