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
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - June 2024
Check out the June 2024 Power BI update to learn about new features.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
