Forum Discussion
Stacked Line Charts Across Date
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.
Sean,You are right in regards to how Excel works and basically that is exactly what I need to replicate if possible.
dhouchin You can try something like this set up (although you'll have to adjust for your Fiscal Year)
dhouchin I think the October Update may help you!
Read the Section for "Improved Date Axis Range Formatting" here
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/
It seems we got excatly the bahavior I mentioned - make the chart smaller and the Axis Labels adjust automatically!
However the X-Axis has to be continous for this to work!