Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    sort by absolute value

    Vote (2) Share
    Power BI Ideas Admin's profile image

    Power BI Ideas Admin on 15 Feb 2020 01:28:03

    You can sort by a value ascending or descending, but I want to be able to sort by the absolute value so that the big deltas are on top.

    I know I can create a new measure that calculates the absolute value, but then that measure has to be in my visual and it is then clunky to hide it.

    Definitely streamline the process to just be able to sort by it.

    Thanks!

    Comments (1)
    Power BI Ideas Admin's profile image Profile Picture

    Power BI Ideas Admin on 06 Jul 2020 00:09:05

    RE: sort by absolute value

    This is necessary to use excellent matrix charts to sort variances by magnitude. Excellent idea.