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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

In you data select the monthname (Jan Feb Etc)

Then go to the Columns Tools Tab and Select Sort By column.

There select the Monthnumber.

 

For sorting in visuals select the 3 dots (...) and go to sort by column

Go to the 3 dots again and select the sort order 

  • BI_now's avatar
    BI_now
    Regular Visitor
    5 years ago

    The months are correct in the data like you can see here:

     

     

    But when I sort by "Verkauf QM" the months are sorted as well. I just want to sort by the sum.

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      Anonymous , if you sort value Verkauf QM, it reorders both sub total and data inside. I doubt that can sort on month after that. If I got it correctly