Forum Discussion
Graph showing x-weeks rolling data over multiple years
Dear all, I have been working on some data that is being reported on a weekly basis (i.e. each week is one data entry). All seemed to work fine until I wanted to refresh my data for the first tim...
Hi Anonymous ,
Add a week column to the table.
week = WEEKNUM('Table'[Date],2)Then use date heirarchy and [week] as x-axis and turn off concatenate labels under format -> x-axis.
To only show the latest number of weeks, you could add the [date] column to visual filter then use Relative date filter feature.
Best Regards,
Jay
Hi Anonymous ,
Add a week column to the table.
week = WEEKNUM('Table'[Date],2)Then use date heirarchy and [week] as x-axis and turn off concatenate labels under format -> x-axis.
To only show the latest number of weeks, you could add the [date] column to visual filter then use Relative date filter feature.
Best Regards,
Jay