Forum Discussion

sid-agarwal's avatar
sid-agarwal
Frequent Visitor
1 year ago
Solved

filter date slicer dropdown

My date slicer/filter is showing very old values - fiscal years from 1970s, which is pointless and goes until FY2045 (again too far).  I want this to be according to the data available in my f...
Need Help
  • sid-agarwal's avatar
    sid-agarwal
    1 year ago

    I could not understand the provided soultions here so I went a different way. Thank you

DataInsights's avatar
DataInsights
Super User
1 year ago

sid-agarwal,

 

Try creating the measure below where 'Date' is your date table:

 

Date Slicer Filter = 
VAR vStartDate =
    CALCULATE ( MIN ( FactTable[Date] ), ALL () )
VAR vEndDate =
    CALCULATE ( MAX ( FactTable[Date] ), ALL () )
VAR vResult =
    SUMX (
        FILTER ( 'Date', 'Date'[Date] >= vStartDate && 'Date'[Date] <= vEndDate ),
        1
    )
RETURN
    vResult

 

Add this measure as a filter to your date slicer: