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

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
4 years ago

I am facing similar issues. When I tried to make relationship it allows only one relationship to be active. If I make created date as active, the no.of cases created at that month is showing correct, but when I add closed. It is only showing the created values in closed. Same when I make closed date as active relationship. When I try to activate both the relationship it is throwing error.