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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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.