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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ola7mat
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
Greg_Deckler
Community Champion
Community Champion

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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

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



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors