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 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 !

2 Replies

  • 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 ?