The Data in my excel file is formated as hard coded % number that a person would enter in. I want the number to show as a percent on my Power BI Report but all methods I tried either make is 10000% or 0.0001% neither of which are correct.
thoughts and suggestions?
Go help from a friend.So in power query, I would update the data type to a decimal number first, then load it in, refresh the data in that table (not sure why I needed to do this again but it seemed to clear some saved logic maybe) and then the data type should change to the fixed decimal and then I was able to select percentage and it worked.
Go help from a friend.So in power query, I would update the data type to a decimal number first, then load it in, refresh the data in that table (not sure why I needed to do this again but it seemed to clear some saved logic maybe) and then the data type should change to the fixed decimal and then I was able to select percentage and it worked.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
