Reverse Y axis order
Hey All, Is there a method of reversing the Y axis order for text entries, and if so how? I've read about numerical values being maniputed by multiplying by -1, however I'm working with text. See below for a s/s of what I mean. The text field leads off with a year, and data is coming from a spreadsheet. The year and title of the report references must be kept in one cell... I'd like to have 2021 at the top, followed by preceding years. I've sorted the spreadsheet ascending and descending with no effect. I've sorted the data table and the query both ascending and descending with no effect. Any ideas?
Line and stacked column chart - Y axis % line of every column
I want to change de values of the pink line in % of every column. I mean, I want to show the same scale but with percentages instead of whole numbers in the line. I tried this with a measure but the % does not make sense with every column and the scale of y axis.
