Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.

 

 

 

 

3 Replies

  • Daniel29195's avatar
    Daniel29195
    Community 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! 🤠

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks Daniel,

     

    But, doesn't working yet.

     

     

    This is my database:

     

     

     

  • Anonymous's avatar
    Anonymous
    Not 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.