Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Customise a number format without using FORMAT function

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , in the model view, when you click on a measure or column you get property view, yet it there

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

 

Also referred - https://www.youtube.com/watch?v=vlnx7QUVYME

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , in the model view, when you click on a measure or column you get property view, yet it there

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

 

Also referred - https://www.youtube.com/watch?v=vlnx7QUVYME

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Ahhh... thank you so much! That is one well-hidden little menu. My line graph now looks just grand.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.