Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Hi @stemorri ,
It is not supported for single column to have mixed data types in Power BI.
You may submit this as an idea.
Let me know if I misunderstood your meaning.
Best Regards,
Jay
User | Count |
---|---|
120 | |
67 | |
66 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |