Forum Discussion
BI_now
5 years agoRegular Visitor
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...
- 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 ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
5 years agoSuper User
BI_now , Seem like data is sorted on measure/value, It should be sorted on Rows columns.
Second, you need sort column for the month
Month Sort = month([date])
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column