Visual displaying all data ignoring date filter

[Velvetine27]

Hi,

Im looking for a way to visualize sales data which ignores a certain date filter. I have two date filters that need to be implemented, year and month. What I'd like to have is for example user is selecting Year = 2022 and Month = Aug, the measure will be displaying the sales data from Jan 2022 till Aug 2022. 

Appreciate your help in this matter. Thanks !

[FreemanZ]

hi @Velvetine27 

i propose three steps:

1) try to add a column with this:

YYMM = YEAR([Date])&FORMAT(MONTH([Date]),"00")

2) try to add a measure with this:

RunningTotal =

VAR _value = SELECTEDVALUE(TableName[YYMM])

RETURN

CALCULATE(

    SUM(TableName[Value]),

    TableName[YYMM]<=_value && LEFT(_value,4) =  LEFT(TableName[YYMM],4)

)

3) then create the slicer with YYMM column and Card Visual with the measure,

I tried and it worked like this:

[Velvetine27]

Hey,

Sorry I wasn't being clear, I actually want to display data for each month up till that selected date. With this measure that you provided, it seems to be displaying for that selected month only. Any solution for this ?