As per this post Multiples option for Clustered Bar Combo Chart? - Question & Answer - Amazon QuickSight Community, the workaround is not dynamic and not a long-term solution.
Can support of Small Multiples in Clustered bar combo chart be considered as new feature?