cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JackWren
Frequent Visitor

Conditionally format multiple data type in same column

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

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

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

 

 

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

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

 

 

View solution in original post

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

Thank you

Jack

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors