cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nripendrasinha
Frequent 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!

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!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors