Dynamic filter range

[Anonymous]

Hello!

I have been struggling to set the range on filters, could you please giude on how to achieve this

Attached is the data table with the following details

Id=Autoincriment number as Primary Key
Month=Month Number(Whole Number)
Quarter=Quarter Number (Whole Number)
Year=Year (Whole number) (ex: year has values from 2000 to 2018)

I am looking for a dynamic 'Start year' filter and an 'End year' filter
Logic: How to limit 'end year' values to three years of range (filter drop-down options) from user selected 'start year'

Ex: If data values are from 2000 to 2018 and if user selects 'start year'=2008 then 'End year' should automatically hide all years in the drop down but only show 2008, 2009 and 2010
Start Year=2001 then end year=2001, 2002 and 2003

[v-juanli-msft]

Hi @Anonymous

Based on my test and research, I can't find proper way to achieve this requirement. 

You may submit your idea here.

Best Regrads

Maggie