Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

To change comma position in the Whole Number



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




Super User IV
Super User IV

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


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


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?


I need the comma at 3rd and 6th place



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

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!


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.