cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rtemplin Frequent Visitor
Frequent Visitor

Comma Format count of values in Matrix

I am new to the forum and PBI.  My apologies if I breach any forum protocol.

 

So below is a matrix visualization i have on a report. The values are a count of a non-numeric field.  

 

I want the counts to be formatted as XX,XXX.   So, for example, 15009 would be 15,009.  

 

I do not know a way, let alone the best, to accomplish?

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Comma Format count of values in Matrix

Best way would be to create a measure that does your count like:

 

MyCount = COUNT('Table'[Column])

Then, you can highlight this measure and go to the Modeling tab in the ribbon and click the "," button to format it.

 

image.png

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Comma Format count of values in Matrix

Best way would be to create a measure that does your count like:

 

MyCount = COUNT('Table'[Column])

Then, you can highlight this measure and go to the Modeling tab in the ribbon and click the "," button to format it.

 

image.png

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

rtemplin Frequent Visitor
Frequent Visitor

Re: Comma Format count of values in Matrix

Thank you, Greg.  I greatly appreciate the help and forum guidance.  

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)