Percentage values in powerquery showing up as decimal in report view

[JezMazter]

Hello,

I have values in percentage format which I wish to show in report view. Despite being in percentage formant in powerquery, in the report view the values show up as decimal.

In power query:

In Report view:

Thank you in advance.

[JezMazter]

Thanks! It works! 🙂

[jdbuchanan71]

If you are showing a measure instead of the column you can change the formatting option of the measure as well.

[jdbuchanan71 · Accepted solution]

In the model view of the table, select the column and change the formatting selection: