Forum Discussion

t-atgeor's avatar
t-atgeor
Microsoft Employee
9 years ago
Solved

Custom Numeric Formats inside tables

Hi,   would like to change slightly the formatting of numbers inside tables, similar to the formatting feature in card visuals. For this reason, am using the FORMAT function and converting numbers ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    t-atgeor

     

    To get your desired result, we need to change your number into text with following DAX formula. With number type, we can make it show the result which you mentioned above.

     

    Per Col = 
FORMAT ( Table1[Percent], "#,##0.00%;($#,##0.00%)" )
    Num Col = 
IF (
    Table1[Number] >= 1000000,
    FORMAT ( Table1[Number], "#,##0,,m" ),
    IF (
        Table1[Number] >= 1000,
        FORMAT ( Table1[Number], "#,##0,k" ),
        FORMAT ( Table1[Number], "General Number" )
    )
)

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

t-atgeor

 

To get your desired result, we need to change your number into text with following DAX formula. With number type, we can make it show the result which you mentioned above.

 

Per Col = 
FORMAT ( Table1[Percent], "#,##0.00%;($#,##0.00%)" )
Num Col = 
IF (
    Table1[Number] >= 1000000,
    FORMAT ( Table1[Number], "#,##0,,m" ),
    IF (
        Table1[Number] >= 1000,
        FORMAT ( Table1[Number], "#,##0,k" ),
        FORMAT ( Table1[Number], "General Number" )
    )
)

 

Best Regards,

Herbert

  • t-atgeor's avatar
    t-atgeor
    Microsoft Employee
    9 years ago

    Hi v-haibl-msft,

     

    thank you for the solution.

     

    Regards,

     

    Atanas