Forum Discussion
Rolling Date Range - X-Axis
Hello, I have a datasource (My Y-Axis) that gives me 52 weeks, it is refreshed once a week with new data and the trims the last week. EX: (Data shows: 4/19/2022 to 4/19/2023 this week, next week 4/26/2022 to 4/26/2023).
I had to also develop a Date Table as well to weave in the Y axis results.
I would like to have a automatic adjustment of the range just showing the MIN and MAX added to show on the visual, rather than a manual range entered:
The Line Graph:
x-axis: Scheduled Completion Date of a Date Table
Y Axis:
Are there any good DAX to use so the date ranges change with the new data refreshes?
4 Replies
Hello, Yes I was wondering if you knew of a simple way to make the line chart just capture day from 'today() and 52 weeks before rather than have to do all this M script and offset dates and such.
X-Axis: Completion Date (means the date the job was completed on)
Y-AXIS: Job Order Measure = count(Merge1[scheduled_completion_date])+0
Hi TylerVono
You can create measures
Measure=min('table'[Date') Measure=max('table'[Date')Then put them to the range
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Yolo Zhu,
So it did not work, I cannot add the measure to the range.
This is my option:
The measure falls under my Tooltips:
Any other options? Min and Max measures not working.
