I was looking for a solution to easily switch the “Sort by column” dynamically. (eg based on a slicer)
So in the situation that you want to swap a financial report from a financial year point of view
to a calendar year point of view.
What I would like is that then, the month order is swapped from
JUL / AUG / SEPT / … / JUN
JAN / FEB / MARCH …/ DEC
Only things I found was something like this:
But that feels a bit hacky / cumbersome? Just wondering if there were other workarounds for this type of scenario.