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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.