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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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