Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Datamart - Date Formating

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 ...
Dataflow
  • Anonymous's avatar
    Anonymous
    3 years ago

    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!

     

v-luwang-msft's avatar
v-luwang-msft
Community Support
3 years ago

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/td-p/1165595 

 

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Learner_007
      Regular Visitor
      3 years ago

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