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
andreazambon
Helper V
Helper V

Show the last N weeks trend

Hi there. 

 

I show you a sample of the report i'm building. 

andreazambon_0-1676847174008.png

 

As you can see, I want to show a trend in my graph. In the left column we have a date filter with years, months and weeks.

Now, the graph should:

  • be indipendent from the date filter (done)
  • show only the last N weeks (format years.numweek) from today. So in this case, the trend I need to see starts from 2023.03 to 2023.07

 

The first condition is quite easy, working with relationship. The second one is tricky for me and it is the one's which I need your help.

 

1 ACCEPTED SOLUTION
FreemanZ
Super User
Super User

hi @andreazambon 

try to feed the filter pane with the Date column and choose "Relative Date", in the last 5 weeks, like:

FreemanZ_0-1676851713704.png

 

View solution in original post

2 REPLIES 2
andreazambon
Helper V
Helper V

Ok, you filtered the date. Nice idea 😉

FreemanZ
Super User
Super User

hi @andreazambon 

try to feed the filter pane with the Date column and choose "Relative Date", in the last 5 weeks, like:

FreemanZ_0-1676851713704.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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