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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.