Forum Discussion

HersonD's avatar
HersonD
Helper I
1 year ago
Solved

Create an accumulated value

Hi,

I want to show an accumulative value in my Line and Stacked column chart. 

X axis - Dates

Y-Axis - Values

Line - Accumulated for each day

Also, can I make it dynamic? I tried making an accumulated column in excel but when i used it in power BI it does not change values when I'm using slicers.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thank you bhanu_gautam

    Hi, HersonD 

    Based on your description, I created the following dataset:

    First, create the following two measures:

     

    Values per day = SUM('Table'[Values]) 
    Accumulate per day = 
    VAR _date = SELECTEDVALUE('Table'[date])
    RETURN 
    SUMX(FILTER(ALLSELECTED('Table'[date]),'Table'[date]<=_date),[Values per day])

     

    Create the following two charts and slicers:

     

     

    Modify the slicer time range and find that you get the correct cumulative for each day:

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you bhanu_gautam

    Hi, HersonD 

    Based on your description, I created the following dataset:

    First, create the following two measures:

     

    Values per day = SUM('Table'[Values]) 
    Accumulate per day = 
    VAR _date = SELECTEDVALUE('Table'[date])
    RETURN 
    SUMX(FILTER(ALLSELECTED('Table'[date]),'Table'[date]<=_date),[Values per day])

     

    Create the following two charts and slicers:

     

     

    Modify the slicer time range and find that you get the correct cumulative for each day:

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.