Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
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.
Hi
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)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
User | Count |
---|---|
94 | |
90 | |
84 | |
76 | |
49 |
User | Count |
---|---|
143 | |
141 | |
109 | |
69 | |
55 |