range of x-axis of a line chart using a date slicer

[Anonymous]

Hi All,

I have a master calendar table with Date,Year, Month, YearMonthShortName and more and a fact table with data from Year 2013 till Year 2018

I have a date range slicer and a trend line chart of sales measure from fact table.

The requirements is as below

Create a chart such that the date range on the chart changes with the selected date on the date slicer.

i want the date x axis to show 13months backwards of any date selected on the date slier. how do i achieve this.

if 1st sept 2018 is selected the date range on the chart reflects 13 months prior till september 2018 .

How do i achieve this .

[MFelix · Accepted solution]

Hi @Anonymous ,

Check if this post helps you achieve the final result.

https://www.justanalytics.com/blog/technical-know-how/how-to-display-last-n-months-data-in-power-bi

[Anonymous]

The below post was able to address my question    https://sql.bi/704248?aff=yt    and https://www.youtube.com/watch?v=d8Rm7dwM6gc 

Thanks for the response @MFelix