Dynamic rolling 12 months across x axis with sum each completed month

[kiddn]

Hi,

Beginner Power BI user here.

I would like to setup a dynamic rolling 12 month line chart that shows totals by month. 

The current line graph shows the year commencing January however I would like it to dynamically update e.g. If last completed month is March then April will show as first month on axis and March will show at end of axis. When April is completed May will show as first month and April as the end month.

I have setup a Master Date table which covers off date, fiscal year, month etc however not sure how to tackle this one.

I have attached a screenshot below of how it currently shows in the visual.

Apologies if I have missed any info off.

Thanks in advance

[kiddn · Accepted solution]

Hi all - will work with fiscal year for now and address at a later point - thanks for responding

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Hardik]

you need to create a calculated column and write a dax query that satisfies your criteria of months and display that column as months

[kiddn]

Hi yes I understand that a calculated column etc will likely be required. I have a date master table as well. Just need to know what the dax formula is or how to construct it.

Thanks

[Hardik]

please share your data for the dax query