• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

powerpivot charts

M

matthew_virgilio

New Member
Hi, how can I sort the values in a powerpivot stacked chart from highest to lowest? It only gives me the option to sort them in abc order. Thanks.
 
@matthew...


You can sort by clicking on row labels > More Sort options > Descending order > and picking corresponding measure.


See this image.

http://img.chandoo.org/pivot/power-pivot-more-sort-options.png


The idea is same as how you would custom sort pivot tables.

http://chandoo.org/wp/2012/05/31/custom-sort-pivot-tables/
 
But how can I sort my chart based on values from highest to lowest and not alphabetical order? I clicked manual in the link you posted to custom sort it, but it doesn't work, and when I try to drag the values, nothing happens. Please advise. Thanks Chandoo.
 
Good day matthew_virgilio


If you follow as Chandoo has pointed out but then click on the down pointing arrow in the box under Desending Order and choose sum of order amount or what ever you have that is your values in the Pivot Chart
 
You must log in or register to reply here.
Back
Top