Setting Precision dynamically

[prashant_ora]

Hi,

I have a value coming from database, but with one condition need to show the 2 decimal value and with other condition show the 4 decimal value in chart. Is it possible in power bi ?

Thanks

Prashant

[v-xuding-msft · Accepted solution]

Hi @prashant_ora ,

You could try using the function of FORMAT.

Measure = IF(MAX('Table 1'[Categories]) = "A",FORMAT(MAX('Table 1'[Values]),"0.00"),FORMAT(MAX('Table 1'[Values]),"0.0000"))

Note : The values will be changed to text type after using FORMAT function. If you need to use the values to calculate, I think it is the best way to use the original values not the measure. It will avoid the limitation of data type and ensure the results accurately.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.