Forum Discussion
Custom income statement visual not displaying when adding Format statement
I have created a custom income statement and everything is working fine except for the three calculations that are percentages instead of dollars. The measure is formatted as percentage, but it's sh...
using FORMAT converts the value to text. You would need to apply FORMAT to all your SWITCH choices.
When I do this format shown below, it works fine. But the red highlighted boxes should be formatted "0.0%" and when I do that, it causes the visual to stop displaying.
looks like your locale needs this to be "0,0%" ?
I changed the three margin formats from "0.0%" to "0,0%" and the visual is still not loading.
See below
I would consider using the dynamic measure formatting (you may have to enable this as it may still be a preview feature) or to collect the value first and the depending on the selected measure format it as currency or percentage.