Skip to main content

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.