Presenting weekly data in one view in graph

[Anonymous]

I need to get my 2019--> weekly data to be presented in one view. If i have the week number as in format yyyy/ww the graph ends up presenting all the values and thus, the graph needs to be scrolled horisontally: 

And if I change the format to yyyyww and to be as whole number, the graph expects there to be values in between the last and first week of the year, and fills the missing values with a line. As in between 201952 and 202001.

Now if I change the X-axis type from continuous to categorical, I end up scrolling horisontally. Is there a way to present the weekly data in one view without the need of scrolling or that the graph fills the missing values?

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please feel free to let me know.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi @Anonymous ,

Unfortunately, this is due to the design of the line chart. If you need a view without scrolling, then you need to set the x-axis to continuous, but that will result in autofill. Consider creating a stacked column chart, which do not autofill.

If you would like to suggest  feature improvements, you may vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

That didn't resolve the issue as needed.

[Anonymous]

Hi @Anonymous ,

In your screenshot it shows all the data without the scroll bar, as well as 201952 to 202001 is not being auto-populated with data, it shows blank. Is this not your expected result? Please point out if I have misunderstood you.

Best Regards,

Neeko Tang

[Anonymous]

I was hoping that there wouldn't be a gap in between the last and the first week of years as it is a timeseries and thus there's no gap in between the weeks.

[Anonymous]

Hi @Anonymous ,

We can create calculated columns.

Year = YEAR('Table (3)'[date])

Week = WEEKNUM('Table (3)'[date])

Then we can create a hierarchy.

Note that you need to set the x-axis without the visual object being drilled (i.e. the topmost level). Then drill down as shown below.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.