How to set date range in one drop down list slicer?

[Anonymous]

Hi,

I have to fillfull the following two conditions:

First, It must be a date slicer with drop down list

which it must not be a bar slicer as the picture below.

Second, as the financial year start from April every year, the date shown on the report will be cumulative.

For example, if we select 201805, the report will show the data between 201804 and 201805 and if we select 201902, the report will show the data between 201804 and 201902. 

How can I solve this problem?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

One sample for your reference, Please check the following steps as below.

1. Create a calculated table.

ym = DISTINCT('Table'[Year Month])

2. New two calculated columns in it and format them as whole number.

Month = RIGHT('ym'[Year Month],2)

Year = LEFT('ym'[Year Month],4)

3. Create a measure as below and make the visual filtered by the measure.

Measure = 
VAR ym1 =
    SELECTEDVALUE ( 'ym'[Year Month] )
VAR mon =
    SELECTEDVALUE ( ym[Month] )
VAR year =
    SELECTEDVALUE ( 'ym'[Year] )
RETURN
    IF (
        mon >= 4
            && MAX ( 'Table'[Year Month] ) <= ym1,
        1,
        IF (
            mon < 4
                && MAX ( 'Table'[Year Month] ) <= ym1
                && MAX ( 'Table'[Year Month] ) >= ( ( year - 1 ) * 100 + 4 ),
            1,
            0
        )
    )

Pbix as attached.