Forum Discussion
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...
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.
Greg_Deckler Thank you for the reply. I am trying your method. Is there an option to upload my pbix file here so that you can have a look?
manicktvs91 Super users can post PBIX files but otherwise you would need to post on OneDrive/Box and share a link