Change Date format to MM-dd-yyyy from mixed datatypes in Attribute column

[Sejal]

On the Attribute column, i have mixed data types. And I want to keep all in Attribute column for matrix visual.

I want to change date (only) to
MM-dd-yyyy format. 

how can I do that ? See attached pic.

[v-zhangti · Accepted solution]

Hi, @Sejal 

After testing, the date and text column format in the same column will be unified as Text. You can format dates, but text cannot coexist. Unfortunately, this is by design. Power BI is now unable to achieve what you need. You can try the following methods.

Column:

Column = IF ( NOT ISERROR ( VALUE ( 'Table'[Attribute] )), 
             FORMAT ( DATEVALUE ( 'Table'[Attribute] ), "mm-dd-yyyy" ),    
             'Table'[Attribute])

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.