Shortening X-axys range for small charts

[PBI_hlpr1]

Hi all,

I need to present a set of small charts as follows:

In the x-axys I have FY periods (from 1 to 12) and in the y-axys the values. As the charts are very small even if I checked the "responsive" option they cannot have more than 6-7 periods in the x-axys otherwise the scroll bar underneath appears and I do not want it.

How can I limit the number of periods to a rolling range say from one period before current date and 5 periods in future?

Can someone help?

Thanks,

C.

[amitchandak · Accepted solution]

@PBI_hlpr1 , on of the option is to have these visuals on the date or YearMonth(YYYYMM , Number type) column, that will make it continuous and might not show scroll  

[PBI_hlpr1]

Thanks @amitchandak ,

it worked perfectly. I had also to fis min and max values in the X axys to make it look perferctly.

Many thanks again!!

Best,

C.