Forum Discussion
Measure to Return Current Week's Sunday Order Count
jbcorlikow It doesn't need to be a manual intervention slider - just set a page level filter for week offset = 0.
My date table in the post link above doesn't have a week offset column, so you'll need to create one:
https://community.fabric.microsoft.com/t5/Desktop/Week-offset-in-Power-Query/td-p/2149004
I don't think that I follow, but that's mostly because I'm learning all of this on the fly as I build out this dashboard. I'm including a screenshot of what I'm attempting to do. My current dashboard has two slicers, store_id which allows me to limit the stats to a single or multiple stores and order_fulfilled_at which is a relative date slider that's show the last 3 months worth of order data.
The top row of cards are my averages for each day of the week which gives us a baseline to measure our current performance off of. The averages use a measure that I created called Avg Orders [day of week] where [day of week] is Sunday, Monday, Tuesday, etc.
The second row of cards are the cards that I'm trying to set up the current week of order data. I want these cards to automatically update with the new week's data as the week completes each day. I sync the data 4 times daily so it'll refresh on a similar cycle.
I then have another measure that I'm using to dynamic chance the font colors of the current week cards. I've named this FontColor [day of week]. Each of these measures compares my Avg Orders measure with the current week measure and then change the color based on whether or not the value is over or under the baseline averages.