Percentage and Number in the same visuzalization

[Chanleakna123]

Team , i have KPI which some number need to be percentage and some need to remain the same. 
What my visual looks like is : 
For Ex : DOI , 13.26 , this number remain on Visualization the same 

But Logistics Cost Per Unit Case : 0.16 , this number need to be percentage % on visualization. 
I have no idea how to build this while these numbers are different label and Can't make it well on visualization and even on the Table visualization itselves. 

My purpose is to get all of those number in the same vusualization If it's DOI , need to be 13 , or if it's logistic cost per case it's 16%. 

please let me know what is the possible way to acheive it. 

[v-qiuyu-msft]

Hi @Chanleakna123,

One measure/column can't return different data type values. In your scenario, you need to use Format() function to change percentage and normal numbers as TEXT type values. 

You can create a calculated column like below: 

Column = IF('Table1'[Column1]="Logistics Cost Per Unit Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft , if i have 2 text turn to Percentage , 

what calculation should i add in the calculated column ? 

 IF('Table1'[Column1]="Logistics Cost Per Unit Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))

[v-qiuyu-msft · Accepted solution]

Hi @Chanleakna123,

If you also would like to return when the Column1 value is "Total SC Costs Per Case", you can modify the condition below:

Column = IF('Table1'[Column1]="Logistics Cost Per Unit Case" || 'Table1'[Column1]="Total SC Costs Per Case",FORMAT('Table1'[Column2],"Percent"),FORMAT('Table1'[Column2],"General Number"))

Best Regards,
Qiuyun Yu