Making a line chart without a horizontal bar, how to automatically scale?

[N1ckk]

Hello,

I was wondering if it's possible to make a line chart without a horizontal bar (see picture below).

I want to present all weeks of the year. But 53 weeks doesn't fit!

Is it possible to scale automatically? At the moment i'm using the standard PBI line chart.

[Pragati11 · Accepted solution]

Hi @N1ckk ,

There are 2 things to this:

1. If you want all the x-axis values to be visible from Week 1 to Week 53, then either increase size of your chart by increasing width or increase the page size.
2. If seeing all the x-axis values is not important, then try to make the X-Axis CONTINUOUS type under the formatting settings of your chart. You will get something as below: 

Thanks,

Pragati

[negi007 · Accepted solution]

@N1ckk 

pl. change the x-axis to continnuouns instead of categorial like below

[Pragati11 · Accepted solution]

Hi @N1ckk ,

There are 2 things to this:

1. If you want all the x-axis values to be visible from Week 1 to Week 53, then either increase size of your chart by increasing width or increase the page size.
2. If seeing all the x-axis values is not important, then try to make the X-Axis CONTINUOUS type under the formatting settings of your chart. You will get something as below: 

Thanks,

Pragati