Matrix Rows Ordering Reset after Changing Units from Values to %s (and vica verse)

Hi F_Reh ,

I'm sorry, but could you please provide a sample of the data (don't include any private data!). Is it? It's a good idea to include the field parameters that you use to switch functions. I've done multiple tests, but unfortunately I haven't been able to reproduce what you're experiencing.
Also, if you want to implement toggle between absolute (numeric) values and percentages (%s), there are other ways to do it:
Here's the sample data I used for testing:

In the first way, you can select the matrix and switch the display format in the "value" section:

Or you can use DAX to switch the function, you can refer to this document for specific steps:
Solved: How to toggle between % and absolute values in a m... - Microsoft Fabric Community
I've implemented this method myself in Desktop, and I'll attach the pbix file below.

I've tested both of the above methods, and they don't show the problem you're facing. If you still want to use parameters for the switch, please also provide the necessary sample data and the parameters you are using.

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.