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.
