CODEWITHSUNDEEP
excelsortingpivotssas-tabular
Andrey Morozov
Andrey Morozov

Reputation: 7979

How to sort filter values in descending order in SSAS tabular pivot?

I have a calendar table in my SSAS Tabular model with a "Risk Month Name" column sorted by "Risk Month Number" column.

enter image description here

Having that config gives me month names sorted in the ascending order in the connected pivot table.

enter image description here

I'm trying to sort month names in the pivot filter in descending order.

I understand that I can create an extra calculated column with some values already sorted in the descending order and use this column as a sorting column for the "Risk Month Name" values. But doing this feels wrong and extra complicated for such a simple requirement.

Is there any setting to do it in a proper way?

Upvotes: 0

Views: 726

Answers (1)

GregGalloway
GregGalloway

Reputation: 11625

If you change your RiskMonthNumber column to have a negative sign in front of it the sort order should reverse as you are expecting. If RiskMonthNumber is visible to users then create another hidden column for this purpose.

Upvotes: 1

Related Questions