CODEWITHSUNDEEP
excelpowerpivotslicers
deaddingo
deaddingo

Reputation: 49

Excel Slicer reverse sort order when using Power Pivot "Sort By Column"

I have a bit of a strange one that I need help with.

I am using Power Pivot within Excel to build my data model, which consists of 100K+ rows. I am sorting the "reference number" column by the "total sale price" column, so I can order by the total value. This all works well.

However, when I use a slicer, and set the item sorting to use "data source order", it displays the reference numbers by the lowest sales price to the highest. I want it to show the opposite way, "Highest sales price" first, as that is the most important.

No matter what I do in Power pivot to change the order of the "Total sales price (high to low, or low to high) the slicer does not change.

If I remove the "Sort by column" sorting, it goes back to the reference number ordering, so I know it sort of works.

As the Total sales price value is not a sequential value, I don't think I can use an index column.

Any suggestions would be greatly appreciated.

Thanks

DD

Upvotes: 0

Views: 328

Answers (1)

deaddingo
deaddingo

Reputation: 49

To post the answer I used based off @Jos-wolley suggestion.

I used the RANKX function in a calculated column

Rank all rows as Column = RANKX( 'Table', 'Table'[My Value] )

Upvotes: 1

Related Questions