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

21 Replies

  • jsaunders_zero9's avatar
    jsaunders_zero9
    Responsive Resident
    4 years ago

    Could you talk more about what you are trying to demonstrate by doing this? Sounds like it would look confusing, maybe there is another way to acheive what you need.

  • sandersonmm's avatar
    sandersonmm
    Frequent Visitor
    4 years ago

    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?

     

    • jsaunders_zero9's avatar
      jsaunders_zero9
      Responsive Resident
      4 years ago

      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?

       

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

  • Mayank_Yavda's avatar
    Mayank_Yavda
    Resolver II
    4 years ago

    Hi sandersonmm,

     

    Here, is Line chart with dual x axis which will help you to get secondary x axis, make sure both the dates column is in same table or else they must have a defined relationship( if from different tables ). Hope this helps you.

     

    Line chart with dual x axis PBIVizEdit.comLine chart with dual x axis PBIVizEdit.com

     

     

     

     

     

     

     

     

    Download link for the custom visual file in this page,

    https://pbivizedit.com/gallery/dual-xaxis-line-chart 

     

    Youtube tutorial,
    https://www.youtube.com/watch?v=_yJURZ-KOkY 

     

    This was made with our Custom Visual creator tool PBIVizEdit.com. With this tool,

    • anyone, irrespective of technical skills, can create their own visuals
    • 15 minutes to create a visual from scratch
    • opens up many additional attributes to edit (for e.g. labels, tooltips, legends position, etc)

    Give this a shot and let us know if you face any problem/errors.
    You can use the editor to modify your visual further (some modifications cannot be done in Power BI window and have to be in editor).

    Thanks,
    Team PBIVizEdit