Forum Discussion
Filter with single select without value selected by default
Hi Anonymous
That slicer whouldn't help you the way you want it. I recommend seperating the date (YEAR, MONTH,WEEK...) into different slicers for each of them.
thank you for the answer !
I'm going to use 2 filters (1 for year and another for month) with option multiselection with CTRL hoping that the users won't push ctrl and click many values .
I have a date table which = calendar (min(Invoice[date]),today())
I use the year level of the date hierarchy for the filter on year and it's same for month. I noticed that I have null value in my filters. Do you know why ?
when we reach the next year, my filter will work ?
Yes and it is normal because you have gaps in the column date of the invoice table. Just use the filter pane in the desktop to filter out the blanks