Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
TylerVono
Helper III
Helper III

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:

TylerVono_0-1682541514835.png

The Line Graph:

x-axis: Scheduled Completion Date of a Date Table

 

Y Axis: 

Job Order Measure = count(Merge1[scheduled_completion_date])+0

 

Are there any good DAX to use so the date ranges change with the new data refreshes?

TylerVono_1-1682541538794.png

 

 

4 REPLIES 4
v-xinruzhu-msft
Community Support
Community Support

Hi @TylerVono 

You can create  measures

 

Measure=min('table'[Date')
Measure=max('table'[Date')

 

Then put them to the range

vxinruzhumsft_0-1682651159797.png

vxinruzhumsft_0-1682651330304.png

 

 

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.

 

TylerVono_0-1683331037065.png

TylerVono_1-1683331049027.png

This is my option:

 

TylerVono_2-1683331082249.png

The measure falls under my Tooltips:

TylerVono_3-1683331115815.png

Any other options? Min and Max measures not working.

 

v-xinruzhu-msft
Community Support
Community Support

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)

 

Y-AXIS: Job Order Measure = count(Merge1[scheduled_completion_date])+0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.