display INT as a well formatted date SSAS?

[Anonymous]

I have my Fact table with the below column:

When I display it in a matrix visual, in my pbix I get this:

But in SSAS I see it as:

How can I display it in a nice dd-MMMM-yyyy format?

Ps: the table comes from a ‘sql server’ source with INT data type.

[v-easonf-msft]

Hi, @Anonymous 

For now, it is not possible to modify the column value in SSAS through PowerBI.

Please consider copying another table column in SSAS and changing its data type to Date. 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Anonymous , open power query, and on the first step of change type, try to overwrite the data type as date.

Click on that step and change datatype, it will ask for replace->overwrite step, use that

[Anonymous]

I can't open power query, I am consuming LIVE.

[amitchandak]

@Anonymous , My advice would to bring date column from source

[Anonymous]

I can't change the source.

Furthermore the column is used in a Relationship to connect. Therefore I believe it must be a 'whole number'

[amitchandak]

@Anonymous , please click on column and share column tools properties to chee=ck