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

[rolyzo]

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	200,5
Lloyd	0	300,54	300
Viruez	2	999,99	999,99

and "," is decimal separator

and "." is thousand separator

Thanks!

[v-qiuyu-msft]

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]

Thanks,

But I need to show

Measure 2

200,5

300

999.99

All depent of the column No.Decimal.

Regards.

[v-qiuyu-msft]

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