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!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors