Forum Discussion
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...
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
