I have a data source with sales data by store. Columns in this data include actual sales, forecasted sales, week date, weekending (saturday), region for the store, and which warehouse the store received the sold items from. I need to create a matrix visualization in which the user can filter the average actual data by whichever dates they choose with a slicer and the sum forecasted by whichever dates they choose. The dates can be the same or differing but the dates displayed must be those of the forecasted. The average dates will be in the matrix as well, however they will be matched with the weekday.
The actual data is an average of selected weeks from a slicer.
The forecast is the forecasted value for the displayed weeks
The actual data is matched by day of the week
The data lives in the same source, however I have 2 copies in order to filter them by separate dates and not have the filters affect one another.
What I have
What I desire (the actual week column is to show the data being aggregated)
I'm not sure how to accomplish this nor if this is an advanced or beginner skill. Any assistance or direction is greatly appreciated! Direction in other forums to find answers is also appreciated. For some reason I'm unable to post or make a microsoft forum account.
The actual data is an average of selected weeks from a slicer.
The forecast is the forecasted value for the displayed weeks
The actual data is matched by day of the week
The data lives in the same source, however I have 2 copies in order to filter them by separate dates and not have the filters affect one another.
What I have
What I desire (the actual week column is to show the data being aggregated)
I'm not sure how to accomplish this nor if this is an advanced or beginner skill. Any assistance or direction is greatly appreciated! Direction in other forums to find answers is also appreciated. For some reason I'm unable to post or make a microsoft forum account.
