Formatting in Power BI for summarized fields using Direct Query

Question

Hello,&nbsp;I'm wondering if there is a way to use more precise formatting for values like Count when summarizing a field in a report.&nbsp; It seems like I have some control over formatting, like using commas, when using Average of a field that I formatted.&nbsp; However, I don't see a way to use commas, specifically, for the summary (i.e. count) and the number is always displayed as 1234 (for example).&nbsp;Also, I'm using a card visual that shows average of values.&nbsp; Since I formatted the underlying number, it does use commas in this case.&nbsp; However, I don't see a way to get rid of the two decimal places that it shows.&nbsp;I'm using Direct Query so modeling is limited.&nbsp; I don't seem to be able to create a measure that uses FORMAT() formula, etc.&nbsp;Any suggestions?Thanks!

vanessafvg · Answer

pmoore&nbsp;under your modelling table you should be able adust your formatting including decimal points or using a commma&nbsp;

pmoore · Answer

vanessafvg,&nbsp;Correct, that's what I was referring to - I can format the underlying values (if it is a number) and that translates into sum, average, etc.&nbsp; However, if you do a count, the underlying formatting does not matter and I'm looking for a way to format those count values on the report.

vanessafvg · Answer

pmoore&nbsp;How are you doing your count? &nbsp;Just dragging a text value into a visual and making it count it there?&nbsp;the best way to handle that is to actually create a count measures i.e countrows(tablename) and then format the measure&nbsp;