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

That doesnt make sense at all

Your sales of 44k Verkauf QM happened in January

No matter how you sort the sales happened in January

 

If i understand correctly you would say (when sorting descending) Sales of 83k happened in January. That just is not true

BI_now's avatar
BI_now
Regular Visitor
5 years ago

I do not unerstand what you mean.

 

The customers with highest "Verkauf QM" have to be at the beginning, sort by sum of "Verkauf QM".

But the sales of the month must be in the correct order Jan, Feb, etc.

 

Like this (i do it with cutting just for picture):

 

 

Do you know what I mean?