Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • You are trying to show too much data. Reduce the data points you feed into the visual to below 1000.