cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Daemetius Regular Visitor
Regular Visitor

Issue with data being updated after chaning its column type from decimal to percentage

 

 

Good day all. So I was trying to design a progress bar based on some data imported from Excel. The main focus issue here is the data of progress. I got the % right on excel, but when I import it to PowerBI, it goes back decimal. So I decide to go into edit query and change the column type to percentage. As the picture shows, it reflects the output right, however when I close and apply, the number shown in the visual graph stays as decimal and not percent. (NOTE: The axis should say 100% and not 0.25 on the right end of the graph as well)

 

This issue is happening in PowerBI Desktop. For some reason it works fine in the Web version. It reflects the % right in the visual graph.

 

Anyone knows what could be and how to resolve it? Thank you!

 

 

Issue converting.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Issue with data being updated after chaning its column type from decimal to percentage

Hi @Daemetius,

Click the %Progress column of your table in Fields panel, then make sure that Percentage format is selected under Modeling ribbon. You can review the example in the screenshot below.

1.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
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

1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: Issue with data being updated after chaning its column type from decimal to percentage

Hi @Daemetius,

Click the %Progress column of your table in Fields panel, then make sure that Percentage format is selected under Modeling ribbon. You can review the example in the screenshot below.

1.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,660)