Forum Discussion

am-person's avatar
am-person
Regular Visitor
2 years ago
Solved

100% stack column chart with categorical counts over time

I need help creating a 100% stack column chart.  I created a measure to do a cumulative count on the categories that I am trying to graph:   RT Status count =     CALCULATE(         COUNT(Submit...
Need Help
  • am-person's avatar
    am-person
    Regular Visitor
    2 years ago

    That worked!  Thank you!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      You are welcome.

      • am-person's avatar
        am-person
        Regular Visitor
        2 years ago

        New issue with the new year.  When I adjust the running status count to include the current month with this measure:

         

        Running Status count = CALCULATE([Count],DATESYTD('Calendar'[Date], "31/1"))
         
        The visual just copies over the December 2023 data onto the new month and the January 2024 data is not exhibited in the matrix. 

         

        How to fix this?  Thanks for any help.