Help with dynamic format strings

Looks like what I want to do is not possible. All of my numbers are decimal when they are loaded into Power Query. The only way of determining which one's need to be displayed as a % and which as a whole number, is by referencing the 'Data type' column. There doesn't seem to be a way of using format strings that reference other columns. So, at the moment there is no solution to this. Thanks for everybodies help though.