Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Solved! Go to 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
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.