Conditional Formatted Value

[stemorri]

I have table in which I have unpivoted the columns against an ID variable in order to create one long table with a column called "Variable" and another column called "Value" associated witth each "ID". See an example bellow.

ID	Variable	Value
A	Name	Steve Banks
A	Birth Date	1987/04/03
A	Occupation	Analyst
B	Name	Chris Allison
B	Birth Date	1999/03/02
B	Occupation	Manager
C	Name	Shelley Guade
C	Birth Date	1995/03/05
C	Occupation	Analyst

I am then using a matrix table in Power BI to display the variables and values for each ID. 

the problem I am having is that the default data type in my "Value" column is "text" since that is the data type Power BI is recognizing for the variable "Value". I want to be able to have a condition that can parse this variable and conditionally change the format of "text" to variables that should be formatted as strings and "date" to variables that should be formatted as dates.

Any tips on how to achieve this would be much appreciated.

[Anonymous]

Hi @stemorri ,

It is not supported for single column to have mixed data types in Power BI.

You may submit this as an idea.

https://ideas.powerbi.com/ 

Let me know if I misunderstood your meaning.

Best Regards,

Jay