Showcase only the last 6 months of data for a trendline graph visual

[sreejitjaani]

Hi,

I have a very plain request. I have a trend line graph with data points from Oct 2018 to July 2019. However I want to just display only the tren for the last 6 months from today/ latest month. Currently I am doing by making selections in the visual filter of the graph but I am looking out for a dynamic solution where automatically the graph will display only the latest 6 months data.

Any help would be really appreciated!

Thanks.

[SabineOussi · Accepted solution]

Hi @sreejitjaani 

You can use the relative date filtering.

Just make sure your column is of type Date, drag it to the filtering pane, and choose the latest 6 months.

This also works with a Slicer if you choose its type to be realtive.

Hope this helps!

Sabine O.