Forum Discussion
Dinamic Format
Hi,
I'm trying to configure the values of the table according the metric in column "Nº - Unidade", I'm using a Dinamic Format but I can´t configure the correct format.
See bellow the print of the Dash, and the Dinamic Format formula.
- Anonymous2 years ago
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.
3 Replies
- Daniel29195Community Champion
Anonymous
- Display percentage with 2 decimal places and symbol (%). -- > 0.00%
- Format thousands by dividing by 1,000 and display without decimal places. -- > #,#
- Format millions by dividing by 1,000,000 and display without decimal places. -- > #,###,###
- Format decimal numbers with 2 digits. --> 0.00
- Format integer numbers without decimal places. --> 0
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠 - AnonymousNot applicable
Thanks Daniel,
But, doesn't working yet.
This is my database:
- AnonymousNot applicable
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.