Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All,
Any help with the below issue?
I have created a measure but somehow instead of 0 it is showing me wrong value for a particular day ( Rest days are correct )
Regards
hi @Anonymous
You try using custom format. please refer the link below.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
If my post helps give kudos and accept it as a solution!
Thanks
Hello @Anonymous ,
check this solution https://community.fabric.microsoft.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/652986
Proud to be a Super User! | |
not sure what the issue is, changing the data type to currency and showing only 2 decimals is making it look fine but my rest of the values are still showing wring like below.
Not sure how this abrupt number is coming as a %
@Anonymous , this is a scientific equation because the number is huge.
Proud to be a Super User! | |
This is wrong as it should simplygive 0 as the result, you can see here its simply dividing 2.03 wih 0 and that should throwan error but I have used 0 as an alternative result in my measure so I'm not sure how this number is coming up.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 35 | |
| 33 | |
| 32 | |
| 27 |
| User | Count |
|---|---|
| 136 | |
| 96 | |
| 77 | |
| 67 | |
| 65 |