Forum Discussion
How to build dynamic X-axis showing four weeks back depends on week selected in slicer?
Hi pola
This video might help you take an approach this is not exact solution for sure but with some modification it should work:
1. https://youtu.be/uQPXYW79m3A?si=FaJo5MkYOtt0Q0X42. https://youtu.be/GTHVXaKseZw?si=PYSJYlO4iVwGrz-G
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: www.youtube.com/@HowtosolveprobemRegards
Hi, just in case, this vidoe helped us out to find a solution. Very cool. Show last 6 months based on user single slicer selection (youtube.com)
I did something similar, wanting to display the previous 13 weeks data. I may not have done it the easiest way possible, but it does work for me. Hopefully it will help you!
First of all, I created a new column to calculate the report date which is based on the date of the previous Saturday. Our weeks are viewed Sunday thru Saturday.
WKLY_RPT_ENDDATE = TODAY()-WEEKDAY(TODAY())
I then assigned a number for each of the previous weeks, calling this "WEEKSAGO"
WEEKSAGO = FLOOR((-(DATEDIFF(SOURCE_TABLE[WKLY_RPT_ENDDATE],SOURCE_TABLE[ARRIVALDATE].[Date],DAY))/7)+1,1)
When I build my visualizations, I place a filter for WEEKSAGO>0 and WEEKSAGO<14