I guess the simplest way to achieve this would be:
-
Have a date table with Half Years marked up H1 and H2. I’d recommend the EDNA date table which contains many ways to slice a calendar.
Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum -
Set your report page up with 2 waterfall charts, using the filter pane to filter each with H1 and H2 respectively
Cheers
Pete