Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
sreejitjaani
Regular Visitor

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

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.

1 ACCEPTED SOLUTION
SabineOussi
Skilled Sharer
Skilled Sharer

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.

RelativeDate.PNG

 

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

RelativeDateSlicer.PNG

 

Hope this helps!

Sabine O.

View solution in original post

1 REPLY 1
SabineOussi
Skilled Sharer
Skilled Sharer

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.

RelativeDate.PNG

 

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

RelativeDateSlicer.PNG

 

Hope this helps!

Sabine O.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.