Conditionally format multiple data type in same column

[JackWren]

Hi everyone,

I have a dataset with two columns. The first column contains number values and the other one, the unit. 

I am trying to create a third column that displays the value with the unit but these are two different data types. 

I was wondering if it was possible in PowerBi to create a column that has two different data types but conditionnally ?

if Unit = %, then show realisation in percentage, otherwise show realisation as a whole number. 

Realisation	Unit	New Column
50	%	50% (percentage)
100		100 (whole number)
75	%	75%
105	%	105%
160	%	160%
20		20

Thank you 

Have a nice day

Jack

[v-easonf-msft · Accepted solution]

Hi, @JackWren 

As of now,  you can only create a column that has only one data type , whether it is a calculated column or a measure.

In your case, It is suggested that you convert the column type to text to display it.

Best Regards,
Community Support Team _ Eason

[JackWren]

Alright, I need to perform calculation on these numbers so I can't. 

Thank you

Jack