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

To change comma position in the Whole Number

Hi,

 

How can I show the Data Label as 12,22,123 instead of 1,222,123.

 

Rgds

Nripendra

5 REPLIES 5
amitchandak
Super User IV
Super User IV

@nripendrasinha , if this a number you can have a format defined

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thanks for the suggestion.

I tried the option however it only has three option and in the standard option it displays the number as 1,222,123 and 12,22,123.

 

I want to set the format to 12,22,123

@nripendrasinha 

This is not a valid number format. You need to change the field to text.

 

At which positions do you want to add the commas? Is it third and sixth position?

Noted.

I need the comma at 3rd and 6th place

@nripendrasinha 

 

Try a formula like this in a column and not measure:

Column = LEFT(Table[Field],2) & "," & MID(Table[Field],3,2) & "," & MID(Table[Field],5,10) 

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.