Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
stemorri
Frequent Visitor

Conditional Formatted Value

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.

IDVariableValue
ANameSteve Banks
ABirth Date1987/04/03
AOccupationAnalyst
BNameChris Allison
BBirth Date1999/03/02
BOccupationManager
CNameShelley Guade
CBirth Date1995/03/05
COccupationAnalyst

 

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.

1 REPLY 1
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.