Having different number formats on one dimention

[Ana-guadron]

Hi, so I am working on a dashboard in Lookerstudio, and I have been having trouble at changing the format of specific values within one dimension. 

For example, in my chart, I have the dimension Actual and Montly Target,  the values are sometimes percentages, sometimes currencies and sometimes decimals dependic on the metric ... is there a function that I could use to combine differnt number formats in one calculated field? 

So far I temporary solved the issue by using.. 

CASE WHEN and CONCAT(value, '%')  but this is not ideal as I was using my numbers as ,TEXT datatypes.. so controling my decimals was an issue, . 

Thank you!