Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Creating a cumulative bar chart with additional categories

So i have basically done what is asked for in this post but as a bar chart: https://community.fabric.microsoft.com/t5/Desktop/Problems-with-formula-for-creating-cumulative-counts-for-a-Task/m-p/3374...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

The image i sent is not the finished graph but only an edited version of what i want it to look like. Thats why i said the 3 dots in the image are only because i didnt want to create a bar for the months between april 2025 and january 2026. For practical reasons but they should of course be in the final visual.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

For Dep 3, information is available only for JFM 2026.  There if i swap Year and Month on the X-axis, this is the image i get (with which i see nothing wrong)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, but i need ALL of the monthly amount to be added up in every month after they are added.
    In the ss you shared it resets after each year. I would like it to carry on the data from the previous years and departments.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Yes, thank you very much thats what i have been looking for.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    You are welcome.