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
Thanks for your input! Unfortunately, that is not the same scenario. In my case we want to show data for 4 weeks back depends what week the user selects in slicer. so if user selects week 14 of the year, I want to see weeks: 11,12,13 and 14 on my X axis, when user selects week 20 -- I want X axis to adjust to show 17,18,19, 20.... for some reason filtering does not interact well whit selected value..