Forum Discussion
Dinamic Format
Hi Anonymous ，
FORMAT(SUM(Sales[Sales Amount]), '$#,##0')This formats the sales amount as currency with a thousand separator.
Below is the official link will help you:
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ，
FORMAT(SUM(Sales[Sales Amount]), '$#,##0')
This formats the sales amount as currency with a thousand separator.
Below is the official link will help you:
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.