Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |