cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
howasam
Regular Visitor

Conver Millions to 4.5 Million

I am attempting to use formatting to get my  numbers in millions but I need vsibility to 1 signficant figures after the millions digit. The formual I am using is:

 

Gross Rev Text = FORMAT ( [Gross Revenue], "#,#,M")

 

This takes 4,512,123 and Makes it 4,512M but I want it to show 4.5M. I cannot figure out either how to get the decimal to show instead fo the comma nor how to get it to limit down to less then the full 3 signifcant digitis. In excel this format does what I desire:

 

#.0,,"M"

1 ACCEPTED SOLUTION
chethan
Resolver III
Resolver III

Hi @howasam

 

You Can change the Display Units in Settings in visualization Tab 

 

 

Regards,

Chetan K

View solution in original post

2 REPLIES 2
sgsukumaran
Resolver II
Resolver II


Num Col =
IF (
[Gross Revenue] >= 1000000,
FORMAT ( [Gross Revenue], "#,##0,,m" ),
IF (
[Gross Revenue] >= 1000,
FORMAT ( [Gross Revenue], "#,##0,k" ),
FORMAT ( [Gross Revenue], "General Number" )
)
)

chethan
Resolver III
Resolver III

Hi @howasam

 

You Can change the Display Units in Settings in visualization Tab 

 

 

Regards,

Chetan K

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors