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

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

Anonymous — Sun, 09 Aug 2020 14:35:52 GMT

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.

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

Greg_Deckler — Sun, 09 Aug 2020 14:44:52 GMT

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

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

Anonymous — Mon, 10 Aug 2020 08:13:19 GMT

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.

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

kymramosrpo — Wed, 21 Sep 2022 01:57:16 GMT

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