Can anyone help me work out how to customise a number without turning it into text? I am trying to produce a line graph showing ranking (y) over time (x). As the y-axis is a ranking, 1 is the highest value but apparently Power BI doesn't have the functionality to invert the axis (please please correct me if I'm wrong on this as this would be the simplest solution of all).
As a workaround, I thought I could multiply my rankings by -1, then customise the format of the numbers to make negatives appear as positives. However, the only function I can find to do this is FORMAT, which turns the result into a text string rather than a number, which can't be used as a value on the line graph. I then tried wrapping the whole thing in VALUE, as per below, but this converted the formatted text into a number, i.e. I got my original rankings back! I feel like I have some of the correct elements in play but not in the right order.... this is as far as I got:
measure = VALUE(FORMAT(SUM(ranking),"-##;##"))
(The preset number formats in the Ribbon don't help me here as far as I can tell, but again please tell me if I'm wrong on that!!) Many thanks
