Forum Discussion

BI_now's avatar
BI_now
Regular Visitor
5 years ago
Solved

Sort by sum

Hello,   I hope you can help me. There are a lot of customers with numbers 70009, 70014 and so on. I want to sort by the sum of "Verkauf QM". But Power Bi is sorting the months as well. The month...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi BI_now ,

     

    You want  the "Verkauf QM" column to be sorted in descending order like this and the months are sorted starting from January, right?

     

     

    It's impossible, the value of "Verkauf QM" corresponding to each month is fixed.

    So you either sort the "Verkauf QM" in descending order or sort the month.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

negi007's avatar
negi007
Community Champion
5 years ago

BI_now When you sorting your data, you get option to sort by row or  values. Below data is default sorted

 

 

But when i sort the data by values field, Higher value will come at the top like below and month order will also change

 

 

So you can do sorting by either by value field or rows field.

BI_now's avatar
BI_now
Regular Visitor
5 years ago

But this is not the solution isn't it??

You have to do it with more then one total, look at my example.

 

I want to sort the total (10.622.261, 6.605.161,...) but not the monthly data inside this customer. The months must be in the correct order January, February, March and so on.

 

I can not believe that this is not possible...