Forum Discussion

AmazingRandom's avatar
AmazingRandom
Icon for Helper II rankHelper II
2 years ago
Solved

Cummulative vs individual in a line chart

I have to make a cumulative line chart where the user could see all reports user count summed up (cumulative? Or summarized?), I am not really sure this is doable. The cumulative needs to be able to ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi AmazingRandom ,

    According to your describe, here are my test data:

    1.Create a measure

     

     

     

     

    Running total = 
    VAR X = CALCULATE(
            SUM('Table'[value1]),
            FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
    VAR Y = CALCULATE(
            SUM('Table'[value2]),
            FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
    VAR Z = CALCULATE(
            SUM('Table'[value3]),
            FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
    RETURN X+Y+Z
    

     

     

     

     

    2.Create a line chart

    3.Create a slicer and use data column as value

    4.Final output

    I hope this can help you. If you still can't do it, please provide your documents and hide your personal information.

    In order for you to solve the problem faster, you can refer to the following documentation

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    Best Regards,

    Albert He