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: Nombre No. Decimal Value Value Expected Ken 1 200,56 ...
Data Modeling
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