I need to show highest values on bottom and lowest values on Top in a line chart.

[Anonymous]

Hi All,

         I have created a line chart using my data. I have taken the dates on X axis and took values in Y axis as shown in below picture. Here my requirement is to show highest values on bottom and lowest values on Top which i am not able to it on the chart as it is not showing sorting. When i remove the date on X axis and put some other text value i am able to sort the visual. Can we use any measue or calculated column for this? Can you guys help me out in this issue. Thanks in advance.

[Greg_Deckler]

@Anonymous - I would start with a Top N filter. If that is not sufficient, use something like a Complex Selector to be very specific. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

[Anonymous · Accepted solution]

Create measure to convert all positive values to Negative values as shown in below measure

Invert_SFR = Weekly_SFR[SFR_Calc]*-1

Then click on that measure and goto Measure tools and there in format add this code = #,##;#,##

after adding this the negative sign will disappear and the highest values shows on bottom and lowest values on Top in a line chart as shown in below picture.

[kymramosrpo]

Brilliant! Been racking my brain for weeks till I gave up.

FYI - this neat, simple solution is a great improvement to my bump chart (as instructed by Ruth Pozuelo):

Create a bump or slope chart in Power BI -D70, Curbal (Jun 26, 2019), https://www.youtube.com/watch?v=WW-0MIg8VG0