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.
