Compare 2 KPIs to a dimension

Hello all,

I would like, from the 2 slicers in the picture below, to select only 2 KPI max (among « Total Amount », « Principal Amount », « Contratcts Count », « LGD », ...), and then 1 dimension among « Branch », « Product », « Aging », and « Loan Officer ».

I would like to have a result like the one in the picture below (At the left axis, the first KPI ; eg, the Balance (3,505M $) ; The right axis, the second KPI ; eg, Contracts Count (2780 contacts); And at the horizontal axis, the values of the 2 KPIs for each branch, as the dimension selected was « Branch »).

Here are the tables :

« Table_KPI_2 » :

« Table_DIM » :

And the DAX formulas :

Do you have an idea of how to deal with this ?

I asked a question around this topic in the forum, and the answers helped me to move forward in some steps, but not to the final solution. I come back with much more precision.

With the help of « ThomasFoster » (who showed how to Dynamicaly switch the axis), I arrived to change dynamicaly the dimension, but for only for one KPI. But, here, the user must have the possibility to select at will 2 KPI maxumun, and compare them according to the selected dimension.

Thank you.