Shift timeline of visual

[Anonymous]

How can I shift the time line (x-axis) of a visual for e.g. 6 month?

I have  this data:

this is the sample report:

How can I now shift the time line of only this visual for six month, so it shows data from April to June instead of January to March.

So by sliding the Date slider the bar chart always shows six month ahead.

I kan create a measure to calculate the values but I can't change the x-axis.

Thanks!

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

I think you want to display Last N Months & Selected Month using Single Date Dimension in Power BI.

Please kindly refer to: 

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-power-bi.html

Attached the sample file for your reference.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.