Percentage measure in a view

[MatheusRuiz]

Hello, hope someone can help me on this problem:

I can only see my view correctly when I don't use my measure with the percentage format. 

This is my view (when I use "RETURN 100*calculated_value"), that's working:

I need to display the same values but with a % sign.

When I do that inside the measures with "RETURN FORMAT(calculated_value,"0.0%"), all columns go to 0 and do not display anything in the view.

Does anyone know how to solve this issue?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @MatheusRuiz ,

When you use FORMAT() function, it will return results as text type.

You need to check your type of your measure if it is number type.

If you want to display your number type field as a percentage, just click on the "%" option below.

After clicking the "%" option.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[RMDNA]

Hi @MatheusRuiz - could you post a similar picture of what it looks like when you make that change and it's wrong?