Forum Discussion

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

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.

jsaunders_zero9

Responsive Resident

4 years ago

Like this? CasesByMonth_Example.pbix

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
  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
  - sandersonmm
    Frequent Visitor
    4 years ago
    Hello,
    
    can you share your data souces and relationships? what you posted doesn't work for me.
    
    My Date table, date formated as date
    
    case table, create date and close date are formatted as date
    
    My relationships wont work, when i try to join them
    
    Also i dont know why my x axis wont show the date on the x axis as well
Anonymous
Not applicable
3 years ago
Hello the link has been disabled, could you reshare it please?