How To Show Last 4 weeks Trend In Column Bar chart in Power bi Desktop Using a DAX measure

Do you mean you always want to see the last 4 weeks in the bar chart?

If yes, based on what do you consider a week to be the last one (week of today, week of the most recent fact...)?

My solution would be to create a calculated column in the calendar, showing a "Y" if the date is in the last 4 weeks and a "N" otherwise

Yu can then use that column to filter the values in the X line (or Y line, depend if you have an horizontal or vertical bar chart)

Is this what you want? If yes, please specify how to identify the last week and I shall provide the code

If this helped, please consider giving kudos and mark as a solution

mein replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Koritala Create a Date Table: Ensure you have a Date table in your model.

dax
DateTable =
ADDCOLUMNS (
CALENDAR (MIN(Sales[OrderDate]), MAX(Sales[OrderDate])),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Week", WEEKNUM([Date], 2),
"YearMonth", FORMAT([Date], "YYYY-MM")
)

Create a Measure for Last 4 Weeks Sales:

dax
Last4WeeksSales =
CALCULATE (
SUM(Sales[SalesAmount]),
DATESINPERIOD(
DateTable[Date],
MAX(DateTable[Date]),
-4,
WEEK
)
)

Create a Column Bar Chart

Add Data to the Chart:

Drag the Date field from your Date table to the Axis of the chart.
Drag the Last4WeeksSales measure to the Values of the chart.

Apply a filter to the Date field to show only the last 4 weeks. You can do this by adding a relative date filter in the Filters pane:

Select the Date field in the Filters pane.
Choose "Relative date filtering".
Set it to show the last 4 weeks.
This setup will ensure that your column bar chart always displays the sales trend for the last 4 weeks.

OK

I do not know how you coded your weeks, calendar weeks? ISO weeks?), so my solution might need fixes