Forum Discussion
Line Chart - x axis in categorical view without scrollbar
Hello,
My dataset is related to forecasting, my requirement is to showcase dates from past one year to current date along with future 1 month forecast dates without scrolling the bar in line chart just like how it can be seen in Excel. Using x-axis setting for cateogorical it requires scroll but when i switch it to X-axis setting type to Continuous , the chart is plotted in one view without scrollbar at the bottom of the chart as expected but I will loose my axis as required with dates, now it will group up to month level in the visual which is not part of requirement. Is there a way to display the x-axis as that shown in categoriclal setting type plus overall view that shown in continous setting together without the scrollbar?
I have tried grouping, but it didn't worked as expected.
Expected as below
Power BI Result.
2 Replies
- lbendlin
Super User
You are trying to show too much data. Reduce the data points you feed into the visual to below 1000.
- AnonymousNot applicable
Hi Anonymous ,
It is by design. You may consider to submit this as an idea.
Best Regards,
Jay