Hi,
I have a one pager with week based information.
Report charts
- KPI Chart --> Last weeks sales
- KPI Chart --> YTD Sales (from week 1 to current week)
- Line chart --> Week over week sales
- Matrix / Bar charts --> Information about 1 specific week
Currently experiencing some challenges:
I have made two slicers, the first one is for the Week over week performance, manually select the first week and last week. I prefer to make it dynamic for the last 10 weeks (based on the week of the other slicer, which is the last full week)
The second slicer is being as last week, to show the users the performance of that given week. As I am reporting on Mondays the Monday sales are already included in the data set, and will be shown in the YTD KPI Chart. Preferably these sales will be shown in the next weeks report.
Long story short:
Is it possible to use 1 slicer were you can select the first week and last week, where you are able to show values of the last week in some charts, and YTD in a KPI chart ignoring the 1st week of the slicer as I always want to show YTD from 1st day of the year untill latest value.
I want to prevent adding multiple slicers as it would obstruct user experience.
