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 ...
they are linked by date fields. The date in calendar and the transdate in sales.
Anonymous add a filter to your year and/or week "slicer" to only show items when the "Sales" measure is not blank.
Marco Russo had a great explanation of how/why to do this in a livestream today
https://youtu.be/76CrSzaLbYY?t=1035