Reply
ThuHue_Duong
New Member
Partially syndicated - Outbound

How to format a column with the comma separator in a matrix table on Power BI desktop

Hi there,

I'm using Power BI desktop version Feb-2023. Both of Power BI region and my computer region are English(UK). When creating a matrix table, I got a problem with setting thousand separator. As you can see in the table, the "sum of tripdurationInMinute" has comma separators, while the "count of tripduration" doesn't. The "tripdurationInMinute" column is calculated by the formula: tripdurationInMinute = tripduration/60. How can I change the format of the "count of tripduration" column to get comma separators?

ThuHue_Duong_0-1678271739506.png

Thanks in advance,

Hue

1 ACCEPTED SOLUTION

Syndicated - Outbound

Hi @ThuHue_Duong 

 

You can change the format of the measure by clicking on the measure, then navigate to the Column Tools tab, and in the format pane select the comma. (The same as my first comment)

 

Then you must use the measure in your visual.

 

Here is an example of what it looks like, with the count of  the column (no commas) and the count as a measure (has commas):

HughLa_0-1678278198218.png

 

 Hope this helps you.

Hugh

View solution in original post

7 REPLIES 7
ThuHue_Duong
New Member

Syndicated - Outbound

Hi @Gowtham_Selvam and @HughLa

In my dataset, there is the "tripduration" column, not the "count of the tripduration" column. I navigated to data view and clicked on the comma to change the format of the "tripduration" column before creating the matrix table. That is the picture of the visualization of the matrix table. In the values field, I choose "count" as the calculation, so I get the "count of tripduration" column in the matrix table.

ThuHue_Duong_0-1678274210097.png

Best regards,

Hue

Syndicated - Outbound

I see, sorry I misread that. 

 

You can create a new measure that calculates the count of the tripduration, then change the formatting of the measure.

 

Regards

Hugh

 

Syndicated - Outbound

Hi @HughLa 

How can I change the formatting of the measure? The measure column is not on the table.

Best regards,

Hue

Syndicated - Outbound

Hi @ThuHue_Duong 

 

You can change the format of the measure by clicking on the measure, then navigate to the Column Tools tab, and in the format pane select the comma. (The same as my first comment)

 

Then you must use the measure in your visual.

 

Here is an example of what it looks like, with the count of  the column (no commas) and the count as a measure (has commas):

HughLa_0-1678278198218.png

 

 Hope this helps you.

Hugh

Syndicated - Outbound

Hi @HughLa 

I got it. Thank you very much.

Best regard,

Hue

Gowtham_Selvam
Resolver I
Resolver I

Syndicated - Outbound

Go to Data view ----> Click that count of tripduration column and go to formatting then click comma to display values in comma format.

 

If I answered your question,kindly mark it as solution.

 

Thanks,

GS

HughLa
Resolver IV
Resolver IV

Syndicated - Outbound

Hi @ThuHue_Duong 

 

When you select your measure in the fields pane, the Column Tools tab will appear. In there you can change the formatting of the column.

 

You can click on the comma in the formatting section to have it comma seperated.

HughLa_0-1678272911555.png

 

 

Hugh

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)