Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
In the Power Query I changed the data type to a percentage. I applied the changes, however, the data type in Power BI is still in decimal form. I am trying to have the data types match. Below I have attached a two screenshots showing the tables. Could you provide a solution to this problem?
Power BI:
Power Query:
Solved! Go to Solution.
Hello @Anonymous ,
You can change the column data type to percentage in the report view shown below:
Select the column and under column tools selct the percent icon, you can then change the amount of decimal places.
@Anonymous if this solution worked for you please could you mark as the solution for your question
Hello @Anonymous ,
You can change the column data type to percentage in the report view shown below:
Select the column and under column tools selct the percent icon, you can then change the amount of decimal places.