Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

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
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.