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

Get 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

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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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