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 ...
Anonymous please share the details of the relationship you have between the sales and calendar tables (i.e. what are the key fields being related?)
they are linked by date fields. The date in calendar and the transdate in sales.
Ok Anonymous, you're going to have to provide a little more information if we're going to be able to figure this out...
What is meant by "the year slicer still shows every week for the year"? Can you provide a screenshot unexpected results you're seeing?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