Negative and Positive bar chart ordering

[H_Aqua8]

Hello,

I have a Bar chart in Power BI with both negative and positive values, When i do the bottom top 10 of the visual with sorting by ascending order , the negative appear first and then followed by the positive ones, Is there any ways for the negative value to either be made at the bottom of the visual while keeping the top 10 ascending order or using the absolute value but making the negative to appear different in the bar chart still at the bottom. 

Is there any better visual for negative and positive values?

Thanks

[Anonymous · Accepted solution]

Thanks for the reply from @Joe_Barry , please allow me to provide another insight: 
Hi  @H_Aqua8 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Rankx =
RANKX(
    ALLSELECTED('Table'),CALCULATE(SUM('Table'[Amount])),,DESC)

Flag =
IF(
    [Rankx]<=10 || MAX('Table'[Amount])<0,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Sort axis – Sort descending.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Joe_Barry]

Hi @H_Aqua8 

Are you sorting by the Values? If there is other data in the visual, it could be sorting on this instead. Regarding visuals for Ranking, you could use a funnel or a clustered bar chart.

Hope this helps

Joe