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
I was having an issue with my values on a graph being displayed as a whole number, rather than a decimal as I would like:
Pictured above is the behavior I am talking about, I am dividing, but getting shown a 0, even though the underlying value is clearly a decimal. So I attempted to fix this with FORMAT tool:
This was based on previous suggestion in this thread:
https://community.powerbi.com/t5/Desktop/Graph-Hover-Options/m-p/327631#M146252
However, upon researching, FORMAT returns a string and thus that can explain why my graph looks completely broken.
So then, I change it back to what I originally had:
And now suddently everything works how I originally intended. There were no intermediate steps involved: I broke with FORMAT, and then went back (not undo, just delete the FORMAT text in the Measure box), and then the behavior changed.
So two issues:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.