Forum Discussion

manicktvs91's avatar
manicktvs91
New Member
5 years ago
Solved

Visualization - Line chart with cumulative numbers!

Hi, I have a set of data (for example : number of customer complaints on weekly basis for last 1 year), Now I want to represent it in a line chart with cumulative increasing numbers week on week. wh...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi manicktvs91 ,

     

    You could try measure like below:

    Measure = CALCULATE(SUM('Table'[complaints ]),FILTER(ALL('Table'),COUNTROWS(FILTER('Table',EARLIER('Table'[Year_week])<='Table'[Year_week]))))

     

     

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

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi manicktvs91 ,

 

You could try measure like below:

Measure = CALCULATE(SUM('Table'[complaints ]),FILTER(ALL('Table'),COUNTROWS(FILTER('Table',EARLIER('Table'[Year_week])<='Table'[Year_week]))))

 

 

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

  • manicktvs91's avatar
    manicktvs91
    New Member
    5 years ago

    Hi Liang, Thank you very much. I tried the same with another set of data and it worked. Many thanks

  • manicktvs91's avatar
    manicktvs91
    New Member
    5 years ago

    Hi Liang, V-lianl-msft 

     

    I used the pbix file which you shared in my post and I saw you have queried a table which contains months and counts.

     

    However, I have a list of customer complaints file and how should I create the table which you queried in power query.

     

    I want to create this table by some measures in powerBI itself.

     

    My input table in power query is "List of customer complaints" containing columns "Date of complaint" " Customer name" "Detail of complaint" etc..

     

    I need to create the count of "no. of complaints" for each month as a table and then I have to use your method to put cumulative line graph.

     

    Please help.

     

    Thanks

    Manickaraj