Monday through Friday visualization on one report

[JillianP333]

Every week I analyze productivity for the previous week.  I need to see the overall total which I have, but I would also like to have a separate visualization for M,T,W,Th,F so I can narrow down areas of concern.  How do I do this with one date filter on the report?  Would each visualization have it's own filter?  Thank you.

[jdbuchanan71 · Accepted solution]

If you want a graph for each day you can make a copy of the graph and set a visual level filter to the day of week (Mon, Wed, Thu, etc).  So you would make 5 copies of the graph and set each one to a different week day.  The report level filter of on WeekOffset will keep the correct rolling week dispalyed and each of the graphs will update to the selected day in last week when the week changes.

[v-piga-msft]

Hi @JillianP333 ,

Have you solved the problem with the suggestion of jdbuchanan71?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample which could reproduce the scenario and your desired output so that we could help further on it.

Best Regards,

Cherry

[jdbuchanan71]

Hello @JillianP333 

You can add a column to your date table that calcualtes the week offset from today() so last week is always WeekOffset = -1.

WeekOffset = DATEDIFF(today(),Dates[Date],WEEK)

Then on your report page you add the week offset field as a filter on the whole page and set it to -1.  The report page will always display the dates from last week and will shift automatically when the data set is refreshed and you are in a new week.

[JillianP333]

Thank you, this would provide me with a totals graph of Mon-Fri which is helpful but I'm also looking to have 5 separate graphs, one for Mon, one for Tues, etc. all on the same report.  

In the image attached, I'd like to have the highlighted graph on another page, showing the totals as it does now, then the breakdown by day.

[jdbuchanan71 · Accepted solution]

If you want a graph for each day you can make a copy of the graph and set a visual level filter to the day of week (Mon, Wed, Thu, etc).  So you would make 5 copies of the graph and set each one to a different week day.  The report level filter of on WeekOffset will keep the correct rolling week dispalyed and each of the graphs will update to the selected day in last week when the week changes.

[JillianP333]

Thank you so much, this worked perfectly! 

On my totals graph - is there a way to show which specific date it's using to start the rolling week, i.e, Sunday, September 8, 2019?

[jdbuchanan71 · Accepted solution]

@JillianP333 

You could write a measure like this.

Week Starting = FIRSTDATE ( Dates[Date] )

Then put that somewhere on the page, perhaps in a card so the users would know the time period they are looking at.  Because the WeekOffset filter is applied to the whole page this measure will calculate correctly.