Sorting x-axis by filtered Sales Value while drilled down

Hello everyone,
first time for me to ask for help here, but I really stumbled upon this problem that I am not able to solve.

I have a Sales table with columns Date, Customer, Department, Product, Status, Country and Sales Value.

I want to show the Sales Value of 2023 and 2028 next to each other per Product with Legend of status.

Chart 1 shows what happens if I just put Product and year on the x-axis, Sales into y and Status as legend.

I can only sort this chart by product (alphabetically) or by total Sales (as seen in Chart 2).

The Chart has to be sorted by total Sales in 2028 of that Product, but keep the Years together per product (As I was able to do in Chart No. 3 in the screenshot)
Chart No. 3 is exactly what I want, but to force products to be sorted by total sales in 2028, I had to make a new calculated table, that has no connection to the sales table.

What I really want is exactly the form of chart 3 (sorted by total sales in 2028 but keep the years next to each other per product), but I want to be able to use the slicers for Customer, Department and Country.

So when I select only China for example, I want to see chart 3 but only the products in China.

I included also the measure that I used to get chart 3 working (but only the absolute totals).
Within "Calculated Table", the Products are sorted by the column "Sales in 2028 total".

Of course I could create one calculated table per customer/country/department and then make a really long measure, but I hope there is a better way.

Thanks in advance!
If you need more info, please let me know.