Forum Discussion

MrNoob's avatar
MrNoob
Helper II
8 years ago
Solved

Sorting columns by total size

Hello, So i am trying to sort my Bar chart by Total size of the charts, not the total size of one of the measure, The way i did with excel with PowerPivot was create a measure that added them all together then sorted by that one and colored it white, to hide it.  

 

 

Is there an easier way?

 

So with this, i want the combination of the 3 measures to be how i sort the bars.

 

 

 

 

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi MrNoob

     

    If you click the three dots in the top right hand corner, you may see some options to sort your data.  See if some of these help

     

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi MrNoob

     

    If you click the three dots in the top right hand corner, you may see some options to sort your data.  See if some of these help

     

    • MrNoob's avatar
      MrNoob
      Helper II
      8 years ago

      So this yes was technically the correct answer, but i was trying to do it with 3 separate measures, each bar was a separate and i wanted to sort by the total of those 3 numbers.  However, i was able to get to the correct format with filters.  Thanks for the help. :)