Skip to main content
Microsoft Idea

Power BI

Needs Votes

Ability to sort based on a measure

Vote (105) Share
SQLSzippl's profile image

SQLSzippl on 19 Dec 2015 00:59:49

Being able to sort on a measure or calculation, currently it automatically sorts based on one of the axis. Adding the adding the ability to sort based on measure would be great for sales based metrics. Sorting based on highest commission %, or sales conversion or highest profitable product would be highly useful in more areas than I listed

Comments (3)
SQLSzippl's profile image Profile Picture

lenzy petty on 05 Jul 2020 22:56:07

RE: Ability to sort based on a measure

This would make waterfall charts, and charts in general, more competitive to Tableau

SQLSzippl's profile image Profile Picture

lenzy petty on 05 Jul 2020 22:56:07

RE: Ability to sort based on a measure

would like to see this on waterfall charts

SQLSzippl's profile image Profile Picture

Julian.Payne on 05 Jul 2020 22:32:10

RE: Ability to sort based on a measure

I can't believe you can't use the value (rank of count) of a measure to sort the data in a bar chart...

Like, "which category has the highest count"?

You literally have to rank by the category name (alphabetical!), or write custom dax to rank the counts...

This is super basic analytical stuff.