Datamart - Date Formating

[Anonymous]

Hi,

I'm starting to use datamarts with live conection to sql ddbb, and dataset report conection. 

I can't figure out how to format dates. I set on power query date or datetime formats, close it and load it. Then I go into Column tools within the datamart formating area and choose the date field, 

The field is not recognize as a date and thus it doesn't show the formating date options (neither standard nor personalize).

Does someone expierence the same issue?

Regards

[v-luwang-msft]

Hi @Anonymous ,

 In live connection "data type","data formate" all options are disabled.

The best way is to ask the dataset developer to address that in the original dataset.And you could try create a measure with Format(). 

Measure = FORMAT(SUM('Table'[values]),"General Number")

refer:

https://community.powerbi.com/t5/Desktop/Change-data-format-when-live-connection-at-power-bi-level/t... 

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

Best Regards,
Lucien

[Anonymous · Accepted solution]

I figure out how.

in the relationship tab, slect the atribute you want to fromat, and on the left side will appear the formating panel. 

THanks!

[Learner_007]

This works, but when i connect datamart to Desktop version, its not showing the field with a date hierarchy, Any update on that?