% column in query doesn't appear correctly in table

[Anonymous]

Hi all,

Currently having some % issues. I have several columns set as % in my query, yet they seem to reformat as soon as I bring them into the report. Help greatly appcretiated!   

Kind regards,

Jordan 

[v-lili6-msft · Accepted solution]

hi @Anonymous 

It should be that you need to adjust the data

For example:

0.4% = 0.004

If we show it not as a percent format and as two decimal places, it will show 0.00

Then in power bi data view, we need to format the dataformat as percent.

Result:

BeforeAfter

Regards,

Lin

[Anonymous]

Hi @Anonymous 

Is the value on your table a Calculated Column?

If so you will need to update the data type as this may not be inferred from the source column.

Kevin