Sort column Headers in a Matrix

[vickyd]

Is there a way to sort the columns in a matrix visual?

In below screenshot I want column order to be Won, Pipeline, Lost and not the other way round. I can create 3 measures and place them in that order but that would cause drillthrough functionality to not work as the column is no longer a dimension. 

[parry2k]

it will be in the order how you dropped those on the value in matrix, not sure if I fully understood your question.

[lndnbrg]

I would create an additional column that serves as a sort column for the column values and define a „Sort by“ in the data model.

Like this: https://community.powerbi.com/t5/Desktop/Sorting-Matrix-Table-Values/td-p/41612

[vickyd]

---

@lndnbrg wrote:
I would create an additional column that serves as a sort column for the column values and define a „Sort by“ in the data model.

Like this: https://community.powerbi.com/t5/Desktop/Sorting-Matrix-Table-Values/td-p/41612

---

Ya. I'm aware of this but really painful to introduce a sort by for every single thing that needs to be sorted, especially given I'm using a SSAS cude as the source. Wish there was an easier ad-hoc way to do sorting at the report level without involving the data model. 

[parry2k · Accepted solution]

if you are using SSAS Cube then it is better because it just need to be done once at SSAS Model and that will flow to powerbi.