Forum Discussion
Rolling 12 Month Trend Line when selecting a month
So I am wanting to create a Trend Chart that will show a rolling 12 month trend line. If I select Jan. 2019 as a slicer I want it to show from last January to this one in the trend.
I have been trying to use the below link but this doesn't seem to be working:
I tried this DAX calculation but all of the #'s are coming through the same no matter what month I look at...
I was able to accomplish similar to what you are wanting using the fine article below (has a working example as well)
Good luck,
You'll have to specify another coumn to sort your month name by, say a numerical MonthOfYear field populated with 1 through 12 depending on the month name for the row
You can do this in either the "Report" or "Data" view, by selecting the table then the field you are using in those visualizations, then in the Modeling tab select "Sort by Column" to specify your sort column
4 Replies
blopez11Super User
I was able to accomplish similar to what you are wanting using the fine article below (has a working example as well)
Good luck,
- blopez11
You'll have to specify another coumn to sort your month name by, say a numerical MonthOfYear field populated with 1 through 12 depending on the month name for the row
You can do this in either the "Report" or "Data" view, by selecting the table then the field you are using in those visualizations, then in the Modeling tab select "Sort by Column" to specify your sort column