Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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.