Forum Discussion
Helper IIIPositive vs Negative top ten list
Hi,
This is most likely reall easy , but how can I show a top ten list which includes negative and positive numbers ?
Thank you
5 Replies
craig811Hi,
Thank you for your repley,
Example data:
I have an item with say a Postive value : £103,000 and an Item with a Negative value: £-403,000. The negative value will not show up in my Top ten items as it's a negative.
Do I need to convert them to an absolute value to show them in my top ten list?
- mwegener
Most Valuable Professional
Hi craig811 ,
If you need the absolute value, you can use this DAX function.
https://docs.microsoft.com/en-us/dax/abs-function-dax
- v-diye-msft
Community Support
Hi craig811
Not quite understand your requirement, kindly refer to below similar threads whether help, if not, you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
https://community.powerbi.com/t5/Desktop/How-to-display-only-the-top-10-values-in-a-chart/td-p/32335
https://community.powerbi.com/t5/Desktop/Show-positive-and-negative-in-TOPN-filter/m-p/728442
https://community.powerbi.com/t5/Desktop/topn-dax-for-negative-values/m-p/1034645
- tex628
Community Champion
Make a seperate column or measure where you make all the numbers positive, something along the lines of this:
Column = IF( [Value] < 0 ; [Value] * -1 ; [Value])
Then use the top 10 filter on this column while displaying the correct numbers.
/ J
