Forum Discussion

sandersonmm's avatar
sandersonmm
Frequent Visitor
4 years ago

multiple dates on axis

Hi,   I have 2 dates that I want to plot on the X-axis and a count of case IDs on the Y-axis. I cant seem to be able to add in more than one one dimension onto the X-axis. 
Need Help
Tutorial Requests
jsaunders_zero9's avatar
jsaunders_zero9
Responsive Resident
4 years ago

Using my sample below the 16/04/2022 should show a line for 2 cases opened and a 1 case closed to satisfy your requirement?

 

sandersonmm's avatar
sandersonmm
Frequent Visitor
4 years ago

I would like to see just months on the x axis. So, 1,2,3,4... 12. Then it would count the number of case id on the Y axis.  Based on you example the create date line would have a count of 20 for the month of April and the close date line would have a count of 17 for April and a count of 3 for May.

    • sandersonmm's avatar
      sandersonmm
      Frequent Visitor
      4 years ago

      Yes, that is perfect. However im working on an older version of power bi and cannot open that. Can you send me screen shots of what you did?

      • jsaunders_zero9's avatar
        jsaunders_zero9
        Responsive Resident
        4 years ago

        Good to hear,

         

        TABLES

        _Calendar[Date] joins to Created Date and Closed Date

        MEASURES

        CasesOpened = CALCULATE(COUNTROWS('Cases'),USERELATIONSHIP('Cases'[Created Date],_Calendar[Date]))
CasesClosed = CALCULATE(COUNTROWS('Cases'),USERELATIONSHIP('Cases'[Closed Date],_Calendar[Date]))

        VISUALS

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello the link has been disabled, could you reshare it please?