Hi all,
I know this question has been asked loads but I can't seem to find a solution that works for me.
I have done some reading into this and tried several things such as ABS and RANX (information in links below)
ABS function: https://docs.microsoft.com/en-us/dax/abs-function-dax
RANKX function: https://docs.microsoft.com/en-us/dax/rankx-function-dax
I then stumbled across this thread:
https://community.powerbi.com/t5/Desktop/Sort-Rows-by-Positive-and-Negative/m-p/595886#M283022
This worked wonders and I started to get somewhere with what I wanted but I then hit another roadblock detailed below.
I have an issue where my Matrix table is grouping ID's together and therefore the value of these ID's meaning I am getting distorted values and even some columns with a zero value (where a transaction has come in and gone out therefore leaving a zero value).
Is there a way to stop it grouping like this (a bit like your picture) as again my Top N goes from positive all the way down to negative and not jumbled up (like your picture).
Basically what I'm trying to achieve is the Top N based on value whether or not it is a positive or negative
Example of my matrix table data
ID Name Qty Value
1245 T-Shirt 5 £50
1287 Top 20 £60
1245 T-Shirt -5 -£50
2567 Boots -30 -£200
6947 Socks 200 £100
Current Matrix table:
ID Name Qty Value
6947 Socks 200 £100
1287 Top 20 £60
1245 T-Shirt 0 £0 <<Grouped together but because it's a 0 value I don't want it to show in my Top N table
2567 Boots -30 -£200
I want my table to look like this:
ID Name Qty Value
6947 Socks 200 £100
2567 Boots -30 -£200
1267 Top 60 £60
Any help would be fantastic
Thank you!
