Forum Discussion

H_Aqua8's avatar
H_Aqua8
New Member
2 years ago
Solved

Negative and Positive bar chart ordering

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

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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