Forum Discussion
Working with percentages
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?
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
3 Replies
- AndrejZitnay
Post Patron
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.
AndrejAndrejZitnay - 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