cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Format number as MIllion using ' (e.g. 1'000)

Hello Power Bi coomunity,

 

i hope find everyone health and safe.

My question is about a table that i have that i want to change the number format to this particular million format

Where i have 123,000,000, i want to have just 123'000.

 

I was trying to use this format 

#,,.0M

but i think that im doing something wrong when i change. Can you help me, please?

 

Thanks a lot.

1 ACCEPTED SOLUTION
mahoneypat
Super User
Super User

This custom format string gets this result from 123456000

 

#'###,

mahoneypat_0-1630261853704.png

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
mahoneypat
Super User
Super User

This custom format string gets this result from 123456000

 

#'###,

mahoneypat_0-1630261853704.png

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Hi mahoneypat,

 

in general it works ... thanks so far.

When adding an Symbol for the currency, it is not working anymore. Any suggestion:

 

#'###, --> 2'319 but

#'###, € --> 2318'905 €

 

Anonymous
Not applicable

Thank you so much. It works!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!