cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors