When a stacked bar is coloured by a real dimension, sorting is easy. Colour it by Measure Names and the stack order is fixed by the colour legend, because Measure Names cannot be used in calculations or sorted by another field. Giulio D'Errico wants the clicked measure to drop to the bottom, so he shows two routes. Pivoting the data is quick but risky if your workbook already depends on a wide structure. A scaffold table is more work to set up but keeps the original data intact, so long and wide formats can live in one workbook. Clear screenshots.