Forum Discussion
Kudo CommanderBest Practice for Adding Commas to Numeric Values in Production Power BI Reports
manoj_0911 for first you can use the FORMAT function in DAX to format your numbers with commas
FormattedCalls = FORMAT([TOTAL CALLS], "0,0")
And You can also set the format directly in the data model. Go to the data view, select the column you want to format, and then set the format to "Comma-separated" in the column tools and You can also use Decimel places in format option
For 2nd Using the FORMAT function in DAX can have some performance implications, especially if used extensively in large datasets. It can also affect sorting because the formatted values are treated as text. To avoid these issues, it is often better to set the format in the data model or use the built-in formatting options in Power BI Desktop.
For 3 rd I prefer to set the format in the data model or use Power BI Desktop's built-in formatting options. This approach ensures that the formatting is consistent across all visuals and reduces the risk of performance issues. It also makes the report easier to maintain, as the formatting logic is centralized and not scattered across multiple DAX expressions.
Super Usermanoj_0911 for first you can use the FORMAT function in DAX to format your numbers with commas
FormattedCalls = FORMAT([TOTAL CALLS], "0,0")
And You can also set the format directly in the data model. Go to the data view, select the column you want to format, and then set the format to "Comma-separated" in the column tools and You can also use Decimel places in format option
For 2nd Using the FORMAT function in DAX can have some performance implications, especially if used extensively in large datasets. It can also affect sorting because the formatted values are treated as text. To avoid these issues, it is often better to set the format in the data model or use the built-in formatting options in Power BI Desktop.
For 3 rd I prefer to set the format in the data model or use Power BI Desktop's built-in formatting options. This approach ensures that the formatting is consistent across all visuals and reduces the risk of performance issues. It also makes the report easier to maintain, as the formatting logic is centralized and not scattered across multiple DAX expressions.