Working with percentages

[Anonymous]

Hi All

First post on this community so apologies if it screams Newbie or has been asked a million times before.

I have a field in my SharePoint data that in the query i have formatted as a percentage and displays as 93.86% for example, but when i add it to a visualistion of type "Table" is displays at 0.93 - how do i change this please?

[AndrejZitnay · Accepted solution]

Hello @Anonymous

I would change view.

Click on your field and make sure that you select % under modeling.

Sometime I hava to do same in edit query and change column to %.

Hope that helps.

Andrej

[Anonymous]

@AndrejZitnay - so simple yet so effective!! thank you so much! 

[AndrejZitnay]

Hello @Anonymous,

You are welcome.

Sorry about typo errors 🙂

Good luck with your Power BI journey.

This community page is very effective and very helpfull.

No need for google.

Andrej