Dinamic Format

[pauloreis500]

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.

[Anonymous · Accepted solution]

Hi @pauloreis500 ，

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.

[pauloreis500]

Thanks Daniel,

But, doesn't working yet.

This is my database:

[Daniel29195]

@pauloreis500 

• 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! 🤠