Data formats in datamarts

[najmead]

I appreciate this feature is still in preview mode, but...

How do I format fields in a datamart model?  For example, if I select a field that is a whole number, I can see various formatting options, but none of them appear to allow me to format with comma seperators.  There is a 'custom' option, but it doesn't seem to allow me to set what 'custom' means (eg, I can't seem to set it to #,000 or similar).

With date fields, I don't seem to be able to set any format whatsoever -- the format drop-down is completely greyed out.  When building a report off a datamart model, dates appear to be formatted in a long-format, with no option to override.

Are these issues relating to the product being in preview and unfinished?  Or am I missing something?

[v-mengzhu-msft · Accepted solution]

Hi @najmead ,

According to your description, I understand that you have some doubts about modifying the data format in datamart: you want to define the data in your own format, and you find that you cannot modify the date format, his optional column is grayed out.

1.For your first question, I find that the function itself provides some existing custom formats, as the following shows:

 If you want to modify it with your own format ,you can directly enter your format string, you also can refer to this document for available symbols for custom formats Format function (Visual Basic for Applications) | Microsoft Docs

2. for your second question, from my testing, I can change the date format, the format drop-down is available, as the following shows:

you can give me the screenshot to let me know the details, may be you need to check your date column.

And if you don’t want the “long-date” format, you can also use custom function to choose “short date”.

Best regards,

Community Support Team Selina zhu

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