Forum Discussion

t-atgeor's avatar
t-atgeor
Icon for Microsoft Employee rankMicrosoft Employee
10 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
    10 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
Icon for Microsoft Employee rankMicrosoft Employee
10 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
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Hi v-haibl-msft,

     

    thank you for the solution.

     

    Regards,

     

    Atanas