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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.