Forum Discussion

rolyzo's avatar
rolyzo
Icon for Helper I rankHelper I
8 years ago

Show in Matrix Visualization, column with decimal and with out decimal

Please I need to show in matrix visualization in the same column both format with decimal and with out decimal.

 

see the example:

NombreNo. DecimalValueValue Expected
Ken1200,56200,5
Lloyd0300,54300
Viruez2999,99999,99

 

and "," is decimal separator

and "." is thousand separator

 

Thanks!

Data Modeling

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi rolyzo,

     

    You can create a measure: 

     

    Measure 2 = IF(MAX('Table2'[Nombre])="Lloyd",FORMAT(INT(MAX('Table2'[Value])),"General Number"),FORMAT(MAX('Table2'[Value]),"General Number"))

     

     

    Please note this return TEXT values, if return numbers, all values will display as decimal. 

     

    Best Regards,
    Qiuyun Yu

     

     

    • rolyzo's avatar
      rolyzo
      Icon for Helper I rankHelper I
      8 years ago

      Thanks,

       

      But I need to show

       

      Measure 2

      200,5

      300

      999.99

       

      All depent of the column No.Decimal.

       

      Regards.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        8 years ago

        Hi rolyzo,

         

        You can create a calculated column use the Round() function to round decimal number to desired digits. 

         

        Desired = ROUND('Table1'[Value],'Table1'[No. Decimal])

         

         

        Best Regards,
        Qiuyun Yu