Forum Discussion
Formatting in Power BI for summarized fields using Direct Query
Hello, I'm wondering if there is a way to use more precise formatting for values like Count when summarizing a field in a report. It seems like I have some control over formatting, like using co...
The only way I have found around this was using the FORMAT function.
https://msdn.microsoft.com/query-bi/dax/format-function-dax?f=255&MSPPError=-2147217396
https://msdn.microsoft.com/query-bi/dax/pre-defined-numeric-formats-for-the-format-function
https://msdn.microsoft.com/query-bi/dax/custom-numeric-formats-for-the-format-function
You'll have to create a new column for the calculation though.
e.g.
Closed tickets = FORMAT(COUNTROWS('Closed ticket table'),"00,000")
So, this counts the rows in the closed ticket table and formats it to "00,000"
Was the only way I could get the card count to look like 12,456.