Showing text and formatted numbers in Power Pivot in the Values area

[kupe]

Hi,

I have a table with information like below (simplified), where I use CONCATENATEX to show both text and numbers in the same pivot table.
My problem is that I can't format the numbers - so I get 0.75 etc. instead of 75%.

Is there a way to get numbers formatted as values (percentages/integers)?
(I have approx 30 different measures in the Info column, of those 4 is text, rest is a mix of integer and percentages)

I'm thinking if splitting the Info column into 2, 1 for the text and and 1 for the numbers, but I can't that to work.

Best regards

Kurt

 

[sandy666]

Main rule: don't mix different type of data in the same column