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
S3
Helper III
Helper III

Date range on x axis changes based on measure of last week values

Hello everyone, 

I have a measure:

last 7 days Conversions =

VAR tod =
TODAY ()

VAR last7 = tod - 7

VAR last7views =
CALCULATE (
SUM ( 'Conversions'[Value] )+0,
FILTER ( 'Dates', 'Dates'[Date] > last7 )
)
RETURN

last7views

and a graph which shows how many conversions happened during last week. Measure is Y axis, Date is x axis. 

Is there a way to make the x axis show only 7 days, the ones which the measure would return, dynamically with every refresh please? I can't do it manually every time and I don't want to show dates from the beginning. 

Thank you!
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Use the filter pane.  It offers relative date filter options,  including "Last 7 days".

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Use the filter pane.  It offers relative date filter options,  including "Last 7 days".

Thanks!

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.