Forum Discussion
Slicer which choose between specific time periods
We have a bunch of visuals displaying varius Order details from our Order_Table with slicers where you can filter on specific time periods from the Calendar table. For example selecting July shows totals amount of orders in the visuals for that period.
Now my Manager wants to be able to Slice orders on specific campaigns as shown in the campaign table. How do you Create preset time periods in the slicer? (Sadly I only have access to the old slicer fyi).
Tried something like this but as I bound the table-relationship between Campaign[Starting_date] to Calendar_Table[Date] it ofcourse only slice total orders for the specific starting date of the campaign ( 05-02-2025 for campaign 2 for example) instead of the total campaign period.
Order_Table
| Order_ID | Order_Date | Ship_date |
| 1 | 01-07-2025 | 01-07-2025 |
| 2 | 01-07-2025 | 02-07-2025 |
| ... | ... | ... |
Relationshsips
Calendar_Table
| Date | Year | Month |
| 01-07-2025 | 2025 | July |
| 02-07-2025 | 2025 | July |
Campaing_Table
| Campaing | Year | Month | Start_Date | End_Date |
| 1 | 2024 | Dec | 15-12-2024 | 31-12-2024 |
| 2 | 2025 | Feb | 05-02-2025 | 17-02-2025 |
| 3 | 2025 | July | 01-07-2025 | 22-07-2025 |
1 Reply
- MrMatssonFrequent Visitor