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 follow...
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

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