Skip to main content

    Power BI

    New

    Ability to sort based on a measure

    Vote (101) 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

    61dd0c4c 00b9-4934-84a2-74a11b01fb87 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

    61dd0c4c 00b9-4934-84a2-74a11b01fb87 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

    f5358230 743d-4de4-a3d8-cb2b3ae5c9c1 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.