Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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?

 

1 ACCEPTED SOLUTION
AndrejZitnay
Post Patron
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.


Andrej

 

amount.JPGModeling.JPGedid query.JPG

View solution in original post

3 REPLIES 3
AndrejZitnay
Post Patron
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.


Andrej

 

amount.JPGModeling.JPGedid query.JPG

Anonymous
Not applicable

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

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.