Positive vs Negative top ten list

[craig811]

Hi,

This is most likely reall easy , but how can I show a top ten list which includes negative and positive numbers ?

Thank you

[tex628]

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

[v-diye-msft]

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 

[mwegener]

Hi @craig811 ,

can you provide sample data?

[craig811]

Hi,

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]

Hi @craig811 ,

If you need the absolute value, you can use this DAX function.

https://docs.microsoft.com/en-us/dax/abs-function-dax