I have one idea:
You can make multiple horizontal containers. Each container would contain two sheets which shows the different outcomes, ie container 1 has month jan on the left and months feb-dec on the right. Second container has jan and feb on the left, march - dec on the right etc.
Then you can manually size it to be the right size.
The last thing to do is to use the size() table calculation to hide and show the view.
So for example, if the size of the left hand size is 1 (as there's only only january), then the first container will show the two sheets. All the other sheets would be hidden. This means only the ones with the relevant size will appear in your view.
Thank you for your reply!
This is a creative solution that solves the problem, but I'm (ideally) hoping to minimize the number of sheets involved. Speed performance of this dashboard is a top priority and taking an extract is not possible with our data source. I'll run performance tests with this solution, but I'm concerned that when each sheet contains a significant number of metrics, the filtering that needs to be applied across these 23 different sheets will cause slowness during user interaction.