cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ola7mat Frequent Visitor
Frequent Visitor

Simple Formatting Query

Hello i am new to poewr bi and seem to be struggling with what seems a simple matter.

When moving from my query to power bi it seems that my formatting gets lost somehow and i cant understand why?

 

Can anybody help understand what i am missing here to ensure in power bi values are shown as a %?

 

Data shown in query editor:

Capture1.JPG

Data shown in power bi:

Capture2.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Simple Formatting Query

Yeah, I've seen that with percents sometimes. Solution is to select the column, go to Modeling tab and click the % button in the Formatting area.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Simple Formatting Query

Yeah, I've seen that with percents sometimes. Solution is to select the column, go to Modeling tab and click the % button in the Formatting area.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

ola7mat Frequent Visitor
Frequent Visitor

Re: Simple Formatting Query

Thanks i feel really stupid now. appreciate your reply though.

Super User
Super User

Re: Simple Formatting Query

I wouldn't feel that way at all, I agree that it's annoying that the formatting doesn't flow through.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 99 members 3,435 guests
Please welcome our newest community members: