Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Presenting weekly data in one view in graph

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 h...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

That didn't resolve the issue as needed.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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.