Forum Discussion
multiple dates on axis
This is what I would like to achieve, a line for create date and another line for close date. They would both be counting the case id. The idea behind it would to display when the case was open and closed. Maybe there is a better way of displaying it?
ā
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?
- sandersonmm4 years agoFrequent Visitor
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_zero94 years agoResponsive Resident
- sandersonmm4 years agoFrequent Visitor
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?