Custom Date Range for a Couple of Visualisations

[Anonymous]

Hi guys,

I've got a report that looks at all time data, however I want to set up two of the widgets to look at data from the last 30 days. Can anyone please suggest a solution?

[vishnurk · Accepted solution]

If you want to create measure that always calculate for last 30 days as of today for this then you can try as below:

Say you have a measure quantity sold for each days

last_30days_quantity_sold = CALCULATE(SUM(<quantity_sold column>),FILTER(ALL(<tablename>),datecolmn name>TODAY()-30))

[v-jiascu-msft]

Hi @Anonymous,

There are two solutions. 

1. Add a Visual Level filter. 

2. Add slicers and edit the Interaction. 

Best Regards,
Dale