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

     

    • sandersonmm's avatar
      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

       

       

       

      • jsaunders_zero9's avatar
        jsaunders_zero9
        Responsive Resident
        4 years ago

        sandersonmm 

        This error is telling you that there is a relationship from another table that will affect the new relationships you have created.

        If you can send me a screen shot of the entire data model relationship view we can try and work it out. Alternatively the measures that I have provided will work even if the relationships are set as inactive (dotted line).

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