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

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!

     

3 Replies

  • 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?