I need make the line chart with the last 30 days, acording to date selection.
My calendar is linked to my sales table.
Depending on the filter date selection, I need a line chart with the last 30 days.
EJ: DateSales <= "DateSelection" && DateSales >= "DateSelection - 30".
It's not the last 30 days from today. It's from the date selected in the filter.
After my test, you may try to this way as below:
Add a last 30 day column for date table
last 30 date = DATEADD('Date'[Date],-30,DAY )
then use this column for the line chart and basic date column for slicer
when I select date from 2018-03-09 to 2018-03-23 it returns from 2018-02-07 to 2018-02-21
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.