single select but display the range

[Anonymous]

Hi, Here is the data looks like, and the slicer is the datamonth

I want to make it realize that when the slicer select 202112, the data returns when datamonth>=202101 and datamonth <=slicer 202111,

and when the slicer is 202210, the data returns when datamonth>=202201 and datamonth <=slicer 202210,

do you have any solutions to solvecthat? Thanks.

[FreemanZ]

you would need another table for the slicer, the dataset

try to create a measure with this:

ValueYTD =

VAR _Month = MAX(DateTable[DateMonth])

VAR _Year = LEFT(MAX(DateTable[DateMonth]),4)

RETURN

CALCULATE(

    SUM('DataTable'[Value]),

    'DataTable'[DataMonth] <= _Month

        &&LEFT('DataTable'[DataMonth],4) = _Year

)

i tried and it worked like this: