Forum Discussion

MrMatsson's avatar
MrMatsson
Frequent Visitor
1 year ago
Solved

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_IDOrder_DateShip_date
101-07-202501-07-2025
201-07-202502-07-2025
.........


Relationshsips

 


Calendar_Table

DateYearMonth
01-07-20252025July
02-07-20252025July


Campaing_Table

CampaingYearMonthStart_DateEnd_Date
1

2024

Dec15-12-202431-12-2024
22025Feb05-02-202517-02-2025
32025July01-07-202522-07-2025