cancel
Showing results for 
Search instead for 
Did you mean: 
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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.