Filtering x-axis on offset start and end date

Hi SanderTK ,

You can create two date offsets on the event table. Then use this date range as a filter based on it.

Start Date Offset = Events[Start Date] - 10

End Date Offset = Events[End Date] + 10

Create a MEASURE for calculating ticket sales for the date range.

Total Ticket Sales = 
CALCULATE(
    SUM('Ticket Sales'[Sold]),
    FILTER(
        ALL('Calendar'),
        'Calendar'[Date] >= MIN(Events[Start Date Offset]) && 'Calendar'[Date] <= MAX(Events[End Date Offset])
    )
)

Also based on your description, the double date range is not friendly for line charts, I think table is a better option. If the problem persists, please provide detailed test data and screenshots of the desired results.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.