Forum Discussion

Velvetine27's avatar
Velvetine27
Icon for Helper I rankHelper I
3 years ago

Visual displaying all data ignoring date filter

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...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

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's avatar
Velvetine27
Icon for Helper I rankHelper I
3 years ago

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 ?