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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Anonymous
Not applicable

Decimal Issue

Hai All I want to convert this 1 st attached format to the 2nd one

alanpjames_0-1655912475656.pngalanpjames_1-1655912501016.png
I had tried this power bi option as well

alanpjames_2-1655912561609.png

 

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

You could set by this.

original show:

vyalanwumsft_0-1656322026464.png

Set it.

vyalanwumsft_1-1656322130617.png

The final show:

vyalanwumsft_2-1656322155447.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

You could set by this.

original show:

vyalanwumsft_0-1656322026464.png

Set it.

vyalanwumsft_1-1656322130617.png

The final show:

vyalanwumsft_2-1656322155447.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

James-Harpin
Resolver IV
Resolver IV

Hello,

Within Power Query Editor (transform data) you can change the data type to be a percentage as show below:

JamesHarpin_0-1655913199353.png

Let me know if this works for you,

James

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 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.