Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
as you see in the screeshot below, when I load these percentage data, the negative ones stay as Text and I don't know why!!! I cannot convert them to number. There is no Chnage Type step in the query and I disabled automatic detection of data types..
Thank you!
Solved! Go to Solution.
Your column is not converted to a number type, it's still type any. As long as you have the header row in your data instead of promoting them to headers. Ideally you'd format the Excel data as a table, and then no work would even be necessary, except to click the Get Data From Table/Range button.
Once you Promote those headers, you can probably use:
Fixed = Table.TransformColumns(PriorStep, {{"Premium % Change", Number.FromText}})
--Nate
Your column is not converted to a number type, it's still type any. As long as you have the header row in your data instead of promoting them to headers. Ideally you'd format the Excel data as a table, and then no work would even be necessary, except to click the Get Data From Table/Range button.
Once you Promote those headers, you can probably use:
Fixed = Table.TransformColumns(PriorStep, {{"Premium % Change", Number.FromText}})
--Nate
@Sab
Try to right-click on the column, Change Type, and select Percentage.
If this doesn't solve your problem, can you share the M code or explain how the column was built? Check source data as well
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Not many steps at all! It just read the excel, navigate to the sheets and then converts positive percentages correctly, but it does not the negative ones!!!
I tried to change the '-' and the '%' with regular characters but nothing happened!
So the correct change type step (which I don't know where is executed!!!), for the first negative value of -0.3% should have been converted to -0.003
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.