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 |
Helpful resources
Power BI Monthly Update - May 2025
Check out the May 2025 Power BI update to learn about new features.
Fabric Community Update - May 2025
Find out what's new and trending in the Fabric community.
