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

    • dhouchin's avatar
      dhouchin
      Frequent Visitor
      9 years ago

      Sean,You are right in regards to how Excel works and basically that is exactly what I need to replicate if possible. 

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        dhouchin You can try something like this set up (although you'll have to adjust for your Fiscal Year)