filter date slicer dropdown

[sid-agarwal]

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 fact tables (which is probably currently for 2023, 2024, 2025). How can I shorten this list?

Also, once the user select this filter, eg. FY2024, I have another filter option for the user to select the quarter of the year (if they want to use that and narrow down the results further) - Q1, Q2, Q3, Q4. I want this "quarter" filter to be dependent on the FY filter above so that the data shows correctly.

Currently when I click on the Q1 box, the data changes but I am not sure why is it changing as I did not select any year in the FY filter at all, so I assume it is probably selecting the data for all years' Q1 combined?

[v-echaithra]

Hi @sid-agarwal ,

Let us know if you need furthere assistanace, as you mentioned that you tried different ways and if that worked, could you please share the details of the approach you took and mark it as the accepted solution? This will be valuable for other community members who might encounter a similar issue.

Thanks and regards,
Chaithra

[v-echaithra]

Hi @sid-agarwal ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra]

Hi @sid-agarwal ,

That's great to hear that you found an alternative solution. Could you please share the details of the approach you took and mark it as the accepted solution? This will be valuable for other community members who might encounter a similar issue.

Regards,
Chaithra E.

[v-echaithra]

Hi @sid-agarwal ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra.

[sid-agarwal · Accepted solution]

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

[v-echaithra]

Thanks @Ashish_Mathur , @DataInsights  for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Chaithra E

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[DataInsights]

@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: