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
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