Forum Discussion
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...
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.
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.