Date slicer having more month than the date column in date table

[shiex1]

Hello everyone,

I havet this date slicer to select a specific billing cycle (month). The slicer has all 2024 months in the drop down. However, the date column in the date table only has up to March 2024. Can anyone help me understand why the drop down has more months than the values in the table? Additionally, how can i limit the month in the drop down slicer for 2024 to only have January at this point despite that the date values in date table is currently at March 2024.

Thank you.

[talespin]

hi @shiex1 

Date dimension should have all the dates, but you can filter your slider values based on any logic you want.

You could do something like this, modify the logic to your need.

Create a Calculated Column in your Date table.

IsOrderDate =

VAR _CurrSelectedDate = 'Date'[Date]

VAR _IsOrderDate = CALCULATE( MAX(Orders[Order Date]), Orders[Order Date] = _CurrSelectedDate)

RETURN IF( ISBLANK(_IsOrderDate), 0 , 1)

Put a filter on your slicer in Filter pane. It will show only those dates that you want to show.

[lbendlin]

This is standard and recommended behavior.  Your slicer should be fed by your Dates dimension table Date column, not by your fact date column.

Is this actually distracting your report users?