Forum Discussion

dhouchin's avatar
dhouchin
Frequent Visitor
9 years ago

Stacked Line Charts Across Date

So we are working in Power BI and I am having some difficulty with displaying a specific need in a line chart.  In short we track certain types of issues in our CRM.  We need to display the data based not on calendar year but rather by year starting from 7/1-6/30.  Since each entry has a creation time in it's own year, if I use that to display my line chart I cant overlap the data.  What I need to do is be able to break the data down by month/day and display overlapping lines to see peaks in given years.  When I do this by customising a column it displays it the way I want except it has a long chart that you have to scroll through.  I need the ability to display the chart in a Continuous Type so it will simply only take up the space of the width of the chart itself.  The first image is what I have in Power BI currently and the second image is what we need it to do, as it currently does in Excel. 

 

 

 

 

 

 

6 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi dhouchin,

     

    In a line chart, we are able to change the X-Axis type as Continuous via below property:

     

     

     

    But it requires the A-axis field to be Date type or Number type. In your scenario, it seems you are using text data type in A-axis, please change it to Date field like "2016-07-01".

     

    Best Regards,
    Qiuyun Yu 

    • dhouchin's avatar
      dhouchin
      Frequent Visitor
      9 years ago

      v-qiuyu-msft,

       

      I appreciate your reply to this message, however as I noted in my original post, I need to see the data outlined in a method where the different years are their own line and the X axis only shows the Month/Day.  I have tried the formating options you listed below, and they do not work as they show  each year throughout the chart and not one on top of the other.  Is there any other option out there?

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        I think you want to display daily data on a Monthly axis?

         

        In Excel when you change the width of the chart to make it smaller the X-Axis will adjust from days to months and then even start skipping months etc..

         

        So even if you are displaying daily data it will start showing you the Months as you make the chart smaller!

         

        I believe this is what you are asking for - unfortunately PBI will not act the same way you'll get the scroll bar.